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

learn more… | top users | synonyms

0
votes
0answers
37 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
293 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.
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 ...