Home » RDBMS Server » Server Utilities » Moving 10g to 9i (Oracle 10.2.0.3 and Oracle 9.2.0.7)
Moving 10g to 9i [message #354329] Fri, 17 October 2008 14:32 Go to next message
andydba
Messages: 34
Registered: September 2008
Member

Hello,

I need to move a 10g database to 9i. In fact only one schema. In 10g compatibility parameter is not set to 9.2.0. Can I do it using export/import?

What is the way to do it?

Andy
Re: Moving 10g to 9i [message #354330 is a reply to message #354329] Fri, 17 October 2008 14:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just export/import would work.
Use the lower version (9i) to export from 10g database and use same lower version to import into 9i database.
Previous Topic: AutoCommit after DBMS_DATAPUMP.open
Next Topic: Export to dump file with low space.
Goto Forum:
  


Current Time: Sun Dec 04 22:58:53 CST 2016

Total time taken to generate the page: 0.07461 seconds