Not able to access bad file created by DBMS_CLOUD.validate_external_table
SummaryKUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not found
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
BEGIN DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE ( table_name => 'EXTERNAL_83', schema_name => 'HCC', rowcount => 100); END; / SELECT * FROM HCC.VALIDATE$139_LOG;