This discussion is archived
3 Replies Latest reply: Nov 21, 2012 11:19 PM by moslee RSS

Imp user schema into another database

moslee Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points