PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared

PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared

Table of Contents

• 1. 场景
• 2. 错误信息
• 3. 解决方法

1 场景

在 使用数据泵导(expdp)出时，遇到报错。

2 错误信息

错误1:

ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'12.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

错误2:

ORA-39127: unexpected error from call to "SYS"."DBMS_CUBE_EXP"."SCHEMA_INFO_EXP"
ORA-44002: invalid object name
ORA-06512: at "SYS.DBMS_ASSERT", line 401
ORA-06512: at "SYS.DBMS_ASSERT", line 401
ORA-06512: at "SYS.DBMS_METADATA", line 11181
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

3 解决方法

MOS ID: 1328829.1

connect / as sysdba
SELECT * FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP';
CREATE TABLE SYS.EXPPKGACT$_BACKUP AS SELECT * FROM SYS.EXPPKGACT$;
DELETE FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP' AND SCHEMA= 'SYS';
commit;

Author: halberd.lee

Created: 2020-10-23 Fri 15:36

Validate