Sunday , December 22 2024

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

This error is occurs because the statistics belonging to the External Table cannot be collected while collecting the statistics belonging to the tables.

Solution:

We drop the External Tables.

We find the External Tables in the database as follows.

The directories belonging to the SYS user are listed from TOAD. There, the external table tab belonging to each directory is clicked and the tables are found.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *