ORA-29913 ORA-29400 gather schema stats



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/' ; 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post