19c数据库改成12c后兼容性后启动 DataPump 时不存在表或视图:ORA-39006、ORA-39065 和 ORA-00942
[$ /acfs/expdp_dir]$ impdp \'/ as sysdba\' parfile=impdp_xxxx20211021.par
Import: Release 19.0.0.0.0 - Production on Thu Oct 21 18:05:28 2021
Version 19.10.0.0.0
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-00942: table or view does not exist
ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 1548
ORA-06512: at "SYS.KUPM$MCP", line 2710
ORA-39097: Data Pump job encountered unexpected error -942
原因
:GSMADMIN_INTERNAL.CLOUD拥有的CLOUD表不存在
解决
:使用sysdba登录,数据库启动升级模式,执行下面三个脚本,重新创建该表
Oracle升级模式(点此跳转)
#执行以下脚本:
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql