Home » SQL & PL/SQL » SQL & PL/SQL » Data Pump
Data Pump [message #189197] Wed, 23 August 2006 10:29 Go to next message
techvader01
Messages: 17
Registered: August 2006
Location: Los Angeles
Junior Member
I have 3 separate databases. a- Oracle 9i b- Oracle 9i and c- Oracle 10g. Can I use DataPump from an Oracle 10G to export from one Oracle 9i and import to the other Oracle 9i database. Razz

Report message to a moderator

Re: Data Pump [message #189226 is a reply to message #189197] Wed, 23 August 2006 13:18 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
No. See Metalink note:132904.1 (Compatibility Matrix for Export & Import Between Different Oracle Versions)

Report message to a moderator

Re: Data Pump [message #189231 is a reply to message #189226] Wed, 23 August 2006 13:53 Go to previous message
techvader01
Messages: 17
Registered: August 2006
Location: Los Angeles
Junior Member
The metalink note only talks about compatability between the source and target system for the the import/export. In my example the source and target are at the same level of Oracle 9i.

I am looking only for the Oracle 10G instance to perform the DataPump remotely; connecting by a database link to the source for the expdp and then connecting remotely with another database link to the target for the impdp.

Report message to a moderator

Previous Topic: how to call the below function in select query
Next Topic: Explain SQL and using an Index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 01:05:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.