3 Replies Latest reply: Dec 14, 2013 7:49 AM by Paul M. RSS



      I want to import dmp file from UAT server into PROD server,the dmp file contains entire schema's objects. During the imp process, it encounter IMP-00015 errors. Noticed that this errors was due to objects already exists in the PROD. My questions is how can I import dmp file to PROD in case the objects exists, then just replace data **NOT append data. Is it possible ? if not possible what can I do ? FYI, the database is 11g. These are the statement:



      exp ABC123/ABC123! file=C:\Projects\Backup\Upgrade70.dmp log=C:\Projects\Backup\log.txt

      imp ABC123/ABC123!@PRODSEND file=Upgrade70.dmp log=Upgrade70_import.log fromuser=ABC123 touser=ABC123 grants=none