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

    Error loading dump into a machine with multiple schemas


      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 ?