exec
dbms_stats.gather_schema_stats('<schemaname>',CASCADE=>TRUE);
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file test.log
OS error No such file or directory
ORA-06512: at "SYS.DBMS_STATS", line 9375
ORA-06512: at "SYS.DBMS_STATS", line 9857
ORA-06512: at "SYS.DBMS_STATS", line 10041
ORA-06512: at "SYS.DBMS_STATS", line 10095
ORA-06512: at "SYS.DBMS_STATS", line 10072
ORA-06512: at line 1
select
DIRECTORY_NAME, DIRECTORY_PATH from dba_directories;
DIRECTORY_PATH may be set wrong
set correct path
CREATE OR REPLACE DIRECTORY ADMIN as '/apps/app/oracle/product/9.2.0/network/log/' ;