Ora-29913: Error In Executing Odciexttableopen Callout (文档 ID 353642.1)
来源:互联网 发布:壳牌经销商网络大学 编辑:程序博客网 时间:2024/05/22 07:42
APPLIES TO:
Oracle Database - Enterprise Edition - Version 9.0.1.0 to 9.2.0.6 [Release 9.0.1 to 9.2]Information in this document applies to any platform.
***Checked for relevance on 04-May-2012***
*** Checked for relevance on 05-Apr-2016 ***
SYMPTOMS
When trying to run dbms_stats.gather_database_stats it fails with an error:
SYS on 10-JAN-06 at oradev >exec dbms_stats.gather_database_Stats;
BEGIN dbms_stats.gather_database_Stats; END;
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file sh_sales_ext.log
OS error No such file or directory
ORA-06512: at "SYS.DBMS_STATS", line 10070
ORA-06512: at "SYS.DBMS_STATS", line 10564
ORA-06512: at "SYS.DBMS_STATS", line 10751
ORA-06512: at "SYS.DBMS_STATS", line 10845
ORA-06512: at "SYS.DBMS_STATS", line 10825
ORA-06512: at line 1
Verified the issue by the screen shots in the SR, which shows that a call to gather database
stats is failing when trying to locate a log file.
CAUSE
The directories are invalid.
Changing directories (cd) on the OS, to the ones listed in dba_directories reports they cannot be found.
SOLUTION
To implement the solution, please execute the following steps:
1. create or replace directory MEDIA_DIR as '$ORACLE_HOME/demo/schema/product_media/';
2. create or replace directory LOG_FILE_DIR as '$ORACLE_HOME/demo/schema/log/';
3. create or replace directory DATA_FILE_DIR as '$ORACLE_HOME/demo/schema/sales_history/';
- Ora-29913: Error In Executing Odciexttableopen Callout (文档 ID 353642.1)
- ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
- Oracle RAC expdp 错误一例 ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
- What is an ORA-600 Internal Error? (文档 ID 146580.1)
- ORA-06576 error during Drop User (文档 ID 1498610.1)
- ORA-600/ORA-7445/ORA-700 Error Look-up Tool (文档 ID 153788.1)
- ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (文档 ID 1930964.1)
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
- DataPump Import (IMPDP) Fails With Error ORA-39083 Object Type INDEX_STATISTICS (文档 ID 1454880.1)
- ORA-600 Lookup Error Categories [ID 175982.1]
- Diagnosing and Resolving Error ORA-04031 on the Shared Pool or Other Memory Pools (文档 ID 146599.1)
- OGG-00665 OCI Error executing single row select(status = 3135-ORA-03135: connection lost contact
- Error executing link.exe.
- 解决Error executing aapt.
- Error executing cl.exe
- ogg_Fatal error executing DDL
- ORA-23616: Failure in executing block 3 for script 删除queue的方法
- Unknown failure (at android.os.Binder.execTransact(Binder.java:565))Error while Installing APKs
- 索引的学习及使用
- [Android][第一行代码][第 6 章 数据存储]
- java实体类重写toString方法,得到想要字符串
- 2 判断手机号码
- Ora-29913: Error In Executing Odciexttableopen Callout (文档 ID 353642.1)
- Redis简易教程
- windows环境下unistd.h缺失解决方法
- springboot集成ueditor
- vim 粘贴时取消自动换行
- 给程序添加一个启动界面
- 我们承包了云栖大会阿里大数据专场,10月11日请你来
- js算日子的方法
- viewpager+fragment+tablayout适配器和fragment的一些应用