3 Replies Latest reply: Nov 22, 2012 1:19 AM by moslee RSS

    Imp user schema into another database

      Oracle 9i Enterprise Edition (
      Windows Server 2003 (32 bit)
      --- to ---
      Oracle 11g Enterprise Edition (
      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.