Home » RDBMS Server » Server Utilities » EXPDP (10.2.0.3, Windows 2003)
EXPDP [message #388363] Tue, 24 February 2009 08:25 Go to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Hi all,

I've a 10g export dump file using expdp and I need to import it onto 9i database. Is it possible to import this data??

Thanks a lot

Report message to a moderator

Re: EXPDP [message #388370 is a reply to message #388363] Tue, 24 February 2009 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it is not possible.

Regards
Michel

Report message to a moderator

Re: EXPDP [message #389028 is a reply to message #388363] Fri, 27 February 2009 01:09 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
If you have the only dumpfile then workaroung you can do,
1. Import into 10g database using data pump import.
2. Export the data from 10g database using 9i exp.
3. Import the dump into 9i database.

Report message to a moderator

Previous Topic: How to use Dynamic data file name in SQL*Loader control file? (merged)
Next Topic: SQLLOADER ISSUE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 05:13:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.