9 Replies Latest reply: Aug 7, 2013 5:10 AM by tennek RSS

    Error loading dump into a machine with multiple schemas

    tennek

      I have a machine that has multiple schemas, i was able to take dump for schema-1 of the machine, i want to load the dump into schema-2 of the same machine using the command

       

      imp schema-2/password directory=dump_dir dumpfile=schema-1.dmp logfile=schema-1.log

       

      but it returns error code

       

      ORA-31684 object already exit.

      i think its still looking at schema-1.

       

      pls how do i get it to load the dump on schema-2 ?