-
Export 9.2 import 8i question
Hello:
I need to export an schema from an Oracle 9.2.0.1 and import it into an empty Oracle 8i database.
I tried the export and import but it doesnt work.. could somebody help me with this , please .
Marcelo Quesada
:)
-
You will need to use the export utility from the lowest version of the RDBMS.
In your case you will need to use the 8i one.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Originally posted by jovery
You will need to use the export utility from the lowest version of the RDBMS.
In your case you will need to use the 8i one.
+
Before using EXP utility of Oracle8i to export Oracle 9i database, you may have to execute catexp8.sql (must be in
oracle9i_home/rdbms/admin/) on Oracle 9i database. This sql script creates lower version views required for oracle8i exp utility.
Then as Jim said, use Oracle 8i exp utility to export Oracle9i databaase and import using 8i IMP utility...
HTH
Sameer
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|