7 Replies Latest reply: Oct 5, 2012 9:44 AM by 659603 RSS

    import from 9i to 11g problem

    659603
      I have a 9i database which I have backed up using exp

      exp system@fmz.world file=FMZfull.dmp log=FMZfull.log full=y


      Then I went to import it into a freshly vanilla installed 11g database.

      When using 11g impdp to import from the the 9i exp it errors.

      imp system@fmz.world file=FMZfull.dmp log=imp_ops_maintfml_from_FMZfull_usingimp.log fromuser='ops$maintfml' touser='ops$maintfml'


      Import: Release 11.2.0.3.0 - Production on Mon Oct 1 17:43:52 2012

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.


      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      Export file created by EXPORT:V09.02.00 via conventional path
      import done in US7ASCII character set and AL16UTF16 NCHAR character set
      import server uses WE8ISO8859P1 character set (possible charset conversion)
      . importing OPS$FIN304's objects into OPS$FIN304
      IMP-00003: ORACLE error 1435 encountered
      ORA-01435: user does not exist
      Import terminated successfully with warnings.
      $ ORA-01435: user does not exist
      Import terminated successfully with warnings.



      The user exists in the log file as having been backed up.

      Any ideas please ???

      Edited by: user5856470 on Oct 5, 2012 7:41 AM