OraFAQ Forum: Server Administration » Migration from 8i to 10g

Home » RDBMS Server » Server Administration » Migration from 8i to 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration from 8i to 10g [message #204324]

Mon, 20 November 2006 02:59

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?

Report message to a moderator

Re: Migration from 8i to 10g [message #204326 is a reply to message #204324]

Mon, 20 November 2006 03:05

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.

Report message to a moderator

Previous Topic:	Exp from 10g and imp into ora9i
Next Topic:	Integrity constraints while migrating

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:37:27 CDT 2024