Home » RDBMS Server » Server Administration » Oracle Migration from Oracle 10g to Oracle 8i
Oracle Migration from Oracle 10g to Oracle 8i [message #229443] Sun, 08 April 2007 01:00 Go to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi gurus,

I have windows 2000 server with Oracle 10g database running. I want the same databse migration from Oracle 10g to Oracle 8i version. Actually it is downgrade. The reason is that i have Oracle 10g at my corporate office and oralce 8i is in branch office. The new branch office will have the oracle data equalent from corporate and branch office.

In my branch office i want to use only oralce 8i. Please give the solution.


Thanks,

Mohan Reddy
Re: Oracle Migration from Oracle 10g to Oracle 8i [message #229445 is a reply to message #229443] Sun, 08 April 2007 01:24 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Plan is:
  • export your 10g db with 8i export binary
  • create your new 8i db with all tablespaces and users
  • import in your 8i db schema per schema (or maybe full if you don't have any new 9i/10g features like undo tablespace)

Regards
Michel

Previous Topic: help in handle of archive log files.
Next Topic: apex....
Goto Forum:
  


Current Time: Fri Sep 20 03:33:20 CDT 2024