5M在对库下某几个用户下数据进行数据泵导出时，出现报错
导出命令：expdp ‘/ as sysdba’ dumpfile=main_test_%U.dmp directory=expdpdir compression=all schemas=main_test,MAINTESTREAD,MAINTESTAPP,MAINTESTOPER,MAINTESTAPP,CLAIM_MAIN_TEST logfile=main_test.log parallel=8 cluster=no
报错：
[oracle@CBSDEVDB expdpdir]$ cat main_test.log | grep ORA-
ORA-31693: Table data object “MAIN_TEST”.“T_UW_PRODUCT” failed to load/unload and is being skipped due to error:
ORA-06508: PL/SQL: could not find program unit being called
ORA-31693: Table data object “MAIN_TEST”.“T_GROUP_POLICY” failed to load/unload and is being skipped due to error:
ORA-06508: PL/SQL: could not find program unit being called
ORA-31693: Table data object “MAIN_TEST”.“T_CLAIM_CASE_BAK” failed to load/unload and is being skipped due to error:
ORA-06508: PL/SQL: could not find program unit being called
也尝试使用SYS和临时创建的DBA用户test进行单表导出，也出现报错，如下：
[oracle@CBSDEVDB expdpdir]$ expdp ‘/ as sysdba’ directory=expdpdir dumpfile=test_t1.dmp tables=test.t1
Export: Release 11.2.0.3.0 - Production on Thu Oct 31 18:58:12 2019
Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-04065: not executed, altered or dropped
ORA-04065: not executed, altered or dropped stored procedure “SYS.UTL_RAW”
ORA-06508: PL/SQL: could not find program unit being called: “SYS.UTL_RAW”
ORA-39097: Data Pump job encountered unexpected error -4065
查看SYS.UTL_RAW信息如下：
SQL> select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,STATUS from dba_objects where OWNER=‘SYS’ and OBJECT_NAME=‘UTL_RAW’;
OWNER OBJECT_NAM CREATED LAST_DDL_TIME STATUS
SYS UTL_RAW 20-MAY-13 18-JUL-19 VALID
SYS UTL_RAW 20-MAY-13 18-JUL-19 VALID
请老师们帮忙看看问题出在哪了
sqlplus / as sysdba
set lines 300
show parameter large
show parametr AQ_TM_PROCESSES
col version for a12
col comp_id for a11
col schema like version
col comp_name format a50
col status for a12
select comp_id,schema,status,version,comp_name from dba_registry order by 1;
评论
有用 0SQL> show parameter large
show parametr AQ_TM_PROCESSES
col version for a12
col comp_id for a11
NAME TYPE VALUE
large_pool_size big integer 256M
use_large_pages string true
SQL> SP2-0158: unknown SHOW option “parametr”
SP2-0735: unknown SHOW option beginning “AQ_TM_PROC…”
SQL> SQL> SQL> SQL> col schema like version
SQL> col comp_name format a50
SQL> col status for a12
SQL> select comp_id,schema,status,version,comp_name from dba_registry order by 1;
COMP_ID SCHEMA STATUS VERSION COMP_NAME
APEX APEX_030200 INVALID 3.2.1.00.12 Oracle Application Express
CATALOG SYS VALID 11.2.0.3.0 Oracle Database Catalog Views
CATJAVA SYS VALID 11.2.0.3.0 Oracle Database Java Packages
CATPROC SYS VALID 11.2.0.3.0 Oracle Database Packages and Types
EM SYSMAN VALID 11.2.0.3.0 Oracle Enterprise Manager
EXF EXFSYS VALID 11.2.0.3.0 Oracle Expression Filter
JAVAVM SYS VALID 11.2.0.3.0 JServer JAVA Virtual Machine
ORDIM ORDSYS INVALID 11.2.0.3.0 Oracle Multimedia
OWM WMSYS VALID 11.2.0.3.0 Oracle Workspace Manager
RUL EXFSYS INVALID 11.2.0.3.0 Oracle Rules Manager
XDB XDB INVALID 11.2.0.3.0 Oracle XML Database
COMP_ID SCHEMA STATUS VERSION COMP_NAME
XML SYS VALID 11.2.0.3.0 Oracle XDK
12 rows selected.
评论 有用 0问题解决了。。通过查看失效对象检查到有一个失效函数，编译后导出成功了。。
OBJECT_NAME OBJECT_TYPE STATUS
AQ_EVENT_QTAB_V EVALUATION CONTEXT INVALID
SCHEDULER_EVENT_QUEUE_N RULE SET INVALID
AQ_REMDB_JOBQTAB_V EVALUATION CONTEXT INVALID
SCHEDULER_REMDB_JOBQ_N RULE SET INVALID
AQ_SCHEDULER_FILEWATCHER_QT_V EVALUATION CONTEXT INVALID
SCHEDULER_FILEWATCHER_Q_R RULE SET INVALID
SCHEDULER_FILEWATCHER_Q_N RULE SET INVALID
ALERT_QUE_N RULE SET INVALID
AQ_AQ_AQ_PROP_TABLE_V EVALUATION CONTEXT INVALID
AQ_PROP_NOTIFY_R RULE SET INVALID
AQ_PROP_NOTIFY_N RULE SET INVALID
ALERT_QUE$1 RULE SET INVALID
NameFromLastDDL FUNCTION INVALID
SQL> alter function “NameFromLastDDL” compile;
Function altered.
评论 有用 0墨值悬赏