Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errors — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errors

Accepted answer
16
Views
9
Comments
edited Jun 8, 2020 4:23PM in Autonomous Database 9 comments

Summary

Unable to see validation errors in either VALIDATE$21_LOG or VALIDATE$21_BAD tables

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!