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
Messages: 2
Registered: November 2006
Junior Member
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


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

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

export in Oracle 10g. through original export utilities.

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)


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 Oct 20 19:48:17 CDT 2016

Total time taken to generate the page: 0.16707 seconds