Oracle Database 10g Release 2. Please also tag oracle for search purposes.

learn more… | top users | synonyms

-1
votes
0answers
19 views

ORA-12546 on Windows 2012, Oracle 10g and 11g x64

I am trying to create a database with Database Configuration Assistant. At the very beginning, it stops with this error. Of course, I am logged in as an administrator account, and I have disabled ...
0
votes
0answers
33 views

One Listener for two Oracle Versions

I've got an dev machine with Oracle 10 and 11 running (on separate users) So I want to use only one Listener (the new from 11). I deleted the Listener of Oracle10 and created one on Oracle11. After ...
0
votes
0answers
151 views

Extremely slow datapump imports from 10.2.0.1.0 -> 11.2.0.1.0

All imports/exports talked about here are using datapump, the 10.1.5 system is running on Windows Server 2003 and the 11.2 system is running on Linux. I have an 11gig datapump dumpfile from a 10.1.5 ...
0
votes
0answers
8 views

Check oracle_home if logged in a database

I am connected to a database in a server. How can i check the oracle_home for this database as there are multiple databases on the same server and they all are in different homes.
1
vote
2answers
1k views

Setting the SMTP_OUT_PARAMETER in 10G at runtime

I am writing a procedure that will send mail from oracle 10g. I have installed the UTL_MAIL and UTL_SMTP packages and configured the SMTP_OUT_SERVER parameter. However the requirement is that the SMTP ...
9
votes
1answer
872 views

Column level security

I am in need of a solution to hide specific columns in a table. We have people who need to build reports against this database and specifically some of these tables with confidential information but ...
1
vote
1answer
253 views

Why the optimizer does not use an Index Unique Scan?

I am on Oracle 10.2.0.4.0. I have a big Index Organized Table (IOT) with 74 columns and over 345 million of rows. An external tool execute a batch where I cannot touch the source code. The critical ...
0
votes
0answers
3k views

Extracting node names by looping through xml in Oracle 10G Plsql

I have an XML that looks like below, <email_details> <VENDOR_ID>73</VENDOR_ID> <RGP_NUMBER>1234</RGP_NUMBER> ..... ..... (any number of ...
1
vote
1answer
94 views

SQLPlus Padding in Query Results

I have several Oracle servers that exhibit a behavior I do not understand. I have identified a two node RAC in which one node exhibits the behavior, but the other node does not. RAC is not involved ...
0
votes
3answers
3k views

rename datafile when file does not exists

I am trying to clone our production database in test virtual machine. Our production database works with ASM. I would like to use plain file system in test database. I created database, services, ...
9
votes
3answers
33k views

Calculating percentage of a row over total sum

Apologies for the bad title, I wasn't sure what would be a good title for this. This is currently (simplified view of the) data I'm working with Agent | Commission ---------|------------ ...
2
votes
1answer
6k views

Privileges needed for Oracle Text

I'm new to Oracle Text and I am using it to support a search feature in an application I have written. The everything seems to be working correctly except I'm not happy with the fact that I had to ...
1
vote
1answer
278 views

Does a standby slow down Oracle imp?

I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby). When I import data into the primary server while the standby is started it takes too long to complete ...
2
votes
1answer
1k views

Oracle 10gR2 to 11gR2 upgrade - performance hit [closed]

We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to 11gR2 (11.2.0.3) and we are noticing a significant hit in performance although execution plans are the same for the offended queries before and ...
2
votes
1answer
705 views

How to speed up a query with a lot of subqueries

I have a query which uses a series of functions to return the status of each document for a loan. SELECT loan_number, borrower_name, get_application_status(loan_number, ...
2
votes
1answer
2k views

SSIS PL/SQL task hangs with message “Multiple-step OLE DB operation generated errors.”

I've configured a Microsoft SQL Server 2008 R2 SSIS package with an Execute SQL Task to run a PL/SQL query on an Oracle 10.2 database. The Execute SQL Task (named "SQL Update MY_STATUS flag") is ...
5
votes
4answers
166 views

Getting the value of 'foo' for the closest previous row with higher 'bar'

From this initial data: select level as foo, mod(ora_hash(level),4) as bar from dual connect by level<9; /* FOO BAR ---------------------- ...