1.导入命令
impdp user/passowrd@实例 DIRECTORY=FileDir DUMPFILE=bship_etl_bak.dmp LOGFILE=bship_etl_bak.log CONTENT=DATA_ONLY TABLES=LOG_CDR_5801,SYS_DATATABLE,SYS_DATATABLE_ERROR_MAIN
报错:
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: 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 job encountered unexpected error -1001
- 解决:
执行$ORACLE_HOME/rdbms/admin目录下面的catmet2.sql,utlrp.sql 两个SQL文件即可解决这个问题。
[oracle@h1]$ cd $ORACLE_HOME/rdbms/admin
sql> @catmet2.sql
sql>@utlrp.sql
在执行导入命令就ok