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
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, it is not possible.

Regards
Michel
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.
Previous Topic: How to use Dynamic data file name in SQL*Loader control file? (merged)
Next Topic: SQLLOADER ISSUE
Goto Forum:
  


Current Time: Mon Dec 23 19:51:15 CST 2024