Home » RDBMS Server » Server Administration » Migration from 8i to 10g
Migration from 8i to 10g [message #204324] Mon, 20 November 2006 02:59 Go to next message
qwerty_infy
Messages: 2
Registered: November 2006
Junior Member
Hi
Cna someone tell me if I need to migrate from 8i to 20g using export /import of data, do I need to create the tables first using some scripts in the new database or the import tool itself take care of it?
Re: Migration from 8i to 10g [message #204326 is a reply to message #204324] Mon, 20 November 2006 03:05 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

8i to 20g using export it should be 10g.


You can import first from oracle 8i through original import utilities.

and
export in Oracle 10g. through original export utilities.


like
Oracle 8i
cmd>exp system/oracle full=y

Oracle 10g.
cmd>imp system/oracle


or the import tool itself take care of it?

Import operation create all tables.


YOu have to create if tbs is not exists in Oracle 10g. then first create tbs then perform ur operation.( import)


http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:29426634229263


hope this helps
Mohammad Taj.
Previous Topic: Exp from 10g and imp into ora9i
Next Topic: Integrity constraints while migrating
Goto Forum:
  


Current Time: Thu Dec 08 22:06:12 CST 2016

Total time taken to generate the page: 0.09805 seconds