ylliX - Online Advertising Network
Vertex AI - Antrophic and Mistral models: Why does it require Imegen access?

IMPDP DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS suppress row wise details


I am loading High volume of Data with FK option ( meant only load Parent records are found).

And using DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS to continue the impdp. This may return 1 or 2 billion records with the FK constraint errors which fills the log file. is there any option / workaround to avoid the row wise details to be suppressed ( NOLOGFILE=YES is not option for me as I need a log files to be shared ).

Example , ok to have the below summary but not the detailed one in the below.

872 row(s) were rejected with the following error:
ORA-00001: unique constraint (CONS_TEST_TABLE) violated

Rejected rows with the primary keys are:
Rejected row #1:
column TEST_TABLE_ID: 846
Rejected row #2:
column TEST_TABLE_ID: 847
Rejected row #3:
column TEST_TABLE_ID: 848
Rejected row #4:
column TEST_TABLE_ID: 849
Rejected row #5:
column TEST_TABLE_ID: 850
Rejected row #6:
column TEST_TABLE_ID: 851
Rejected row #7:
column TEST_TABLE_ID: 852
Rejected row #8:
column TEST_TABLE_ID: 853
Rejected row #9:
column TEST_TABLE_ID: 854
Rejected row #10:
column TEST_TABLE_ID: 855
Rejected row #11:

  • ( NOLOGFILE=YES is not option for me as I need a log files to be shared ).



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *