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

Not able to access bad file created by DBMS_CLOUD.validate_external_table

edited Apr 16, 2022 7:54AM in Autonomous Database

Summary

KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not found

Content

We are trying to validate external table using dbms_cloud.validate_external_table procedure. The statement runs fine and as per documentation bad file and log file tables are also created. But whenever we try to select from those tables, Getting below error. Our csv file on which external table is based is on a bucket in Oracle cloud storage. Appreciate if there is any pointers to solve this error?

KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not found

 

 

Code Snippet

BEGIN
DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE (
    table_name => 'EXTERNAL_83',
     schema_name     => 'HCC',
    rowcount        => 100);
END;

 

/

 

SELECT * FROM HCC.VALIDATE$139_LOG;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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