Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Imp user schema into another database

mosleeNov 21 2012 — edited Nov 22 2012

Scenario
=====
Oracle 9i Enterprise Edition (9.2.0.8)
Windows Server 2003 (32 bit)
--- to ---
Oracle 11g Enterprise Edition (11.2.0.3)
Windows Server 2008 Standard R2 (64 bit)

Hi to all

I'm doing a upgrade from 9i to 11g and i am using native imp/exp to migrate those data.. I have exported the schemas from 9i into a dmp file and i am goiing to export them into 11g. 11g database is a new database with no existing schemas..

My newbie question is "Do I have to manually create those exact schema in 11g and their tables before importing data?" If so, there are numerous schemas and objects for me to create.. one by one.. This is the tedious problem i face..
Is there any work around for this? Thanks.

This post has been answered by Richard Harrison . on Nov 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2012

Added on Nov 21 2012

#database-key-features, #export, #export-import-sql-loader-external-tables, #import, #upgrade

3 comments

512 views