Not able to access bad file created by DBMS_CLOUD.validate_external_table

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;