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 ).