DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errors
Summary
Unable to see validation errors in either VALIDATE$21_LOG or VALIDATE$21_BAD tablesContent
I have successfully created an external table in my schema, but when I run the validation procedure it tells me there are errors and to view the log table.
begin
DBMS_CLOUD.validate_external_table(
table_name => 'CUSTOMER_OFFER_EXT',
schema_name => 'SAMPLE_LOADER',
rowcount => 0,
stop_on_error => TRUE
);
end;
/
Error report -
ORA-20003: Reject limit reached, query table "SAMPLE_LOADER"."VALIDATE$21_LOG" for error details
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 943
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1229
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1874
Tagged:
1