Hi guys ,
oracle 11g.2 ASM with RAC under OL 5.6
i always when i check the alert log files i found the below error
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /home/app/oracle/diag/rdbms/absnl/ABSNL1/trace/ABSNL1_j007_15353.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
i search for this error i found the tables that store the data dump was not clean up external tables
but the job of expdp was stoped since 3 months , to avoid this error i just drop the external tables ???
if there is any effected of gather statistics if i not clean the external tables ???