Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Refresh database with import datapump ORA-39112,ORA-31684,ORA-3911

Pablo MartinezMay 31 2019 — edited Jun 3 2019

I'm refreshing a database, use the following:

cat import_gensys.sh

impdp \"/ as sysdba\" parfile=imp.par

cat imp.par

DIRECTORY = ORABACKUPS

FULL = Y

DUMPFILE = FULL_GENSYS_30-05-2019.dmp

LOGFILE = IMPORT_FULLGENSYS_303030-05-2019.log

TABLE_EXISTS_ACTION = REPLACE

EXCLUDE = SCHEMA:"IN ('TVNIA')"

EXCLUDE = TABLE:"LIKE 'TV%'"

But I'm getting a lot of mistakes in the import (ORA-39112, ORA-31684, ORA-39111), could someone give me any suggestions to avoid this?

Previously is it required to perform a step? for example: Disable constraint, triggers, sequences, or something similar.

Comments
Post Details
Added on May 31 2019
3 comments
1,201 views