Home » RDBMS Server » Server Utilities » importing data from 9i to 8i (winxp or developer 6i)
importing data from 9i to 8i [message #301270] Tue, 19 February 2008 22:35 Go to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
AOa
my problem is that i exprot data from oracle 9i using exp command and now want to improt in oracle 8i but after define dmp loation it required buffer size when i press enter the dos screen was automatically closed and not exprot any data

any one help me what problem in buffer sizes
Re: importing data from 9i to 8i [message #301309 is a reply to message #301270] Wed, 20 February 2008 00:42 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
First, export/import are not backup.

Then, to import in 8i database data that come from 9i database you have to use 8i exp binary, not 9i one.

Next time, copy and paste your execution, don't just describe it. If you miss something in your description, how could we see it?

Regards
Michel
Previous Topic: Can't recreate 9i to 10g with EXP/IMP
Next Topic: Loadin filename in a table
Goto Forum:
  


Current Time: Tue Dec 24 22:38:38 CST 2024