重庆思庄Oracle、Redhat认证学习论坛

标题: expdp导出报ORA-39097: Data Pump job encountered unexpected error -1001 [打印本页]

---

作者: jiawang    时间: 2022-8-10 09:16
标题: expdp导出报ORA-39097: Data Pump job encountered unexpected error -1001
环境介绍：
OS：centos 7.8
db:19.3

expdp导出报错：

[oracle@sztech~]$ expdp system/oracle directory=dump_dir dumpfile=dmpfile.dmp  version=11.2.0.4.0  transport_tablespaces='tb1,tb2';

Export:Release 19.0.0.0.0 - Production on Fri Aug 5 17:37:13 2022

Version19.3.0.0.0

Copyright(c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

UDE-28002:operation generated ORACLE error 28002

ORA-28002:the password will expire within 7 days

Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

ORA-39006:internal error

ORA-39065:unexpected master process exception in DISPATCH

ORA-01001:invalid cursor

ORA-06512:at "SYS.DBMS_METADATA_UTIL", line 3405

ORA-06512:at "SYS.KUPM$MCP", line 2635

ORA-39097: Data Pump jobencountered unexpected error -1001

解决办法：

SQL>select count(*) from metanametrans$;

登录/注册后可看大图