我遇到了IMPDP和Oracle DB版本11.2.0.4.0的一个奇怪问题,其中目标模式中确实存在一个表,但IMPDP认为不存在。从导入日志文件中查看以下条目:
从“ EXPORT_USER”开始。“ SYS_IMPORT_TABLE_01”:export_user / ********
目录= EXPORT_DIRECTORY
dumpfile = SMARTCLOUDCONSOLE_OWNER_20170830.dmp
TABLE_EXISTS_ACTION = APPEND DATA_OPTIONS = SKIP_CONSTRAINT_ERRORS
REMAP_SCHEMA = SMARTCLOUDCONSOLE_OWNER:MIKETESTCONSOLE_OWNER
TABLES = SMARTCLOUDCONSOLE_OWNER.ACCOUNTDEPLOYMENTLINKS QUERY =“ WHERE
account_id =(从较低(guid)=的帐户中选择account_id =
'#####')“
处理对象类型SCHEMA_EXPORT / TABLE / TABLE
表“ MIKETESTCONSOLE_OWNER”。“ ACCOUNTDEPLOYMENTLINKS”存在。数据
将被附加到现有表,但所有相关元数据将被
由于附加的table_exists_action而被跳过
处理对象类型SCHEMA_EXPORT / TABLE / TABLE_DATA
ORA-31693:表数据对象
“ MIKETESTCONSOLE_OWNER”。“ ACCOUNTDEPLOYMENTLINKS”加载/卸载失败
并且由于错误而被跳过:ORA-00942:表或视图不
存在
We are using VPDs such that the _owner user owns all of the objects, so I don't think it's a problem of ownership. And it seems like it figures out that the table exists from the second line there Table "MIKETESTCONSOLE_OWNER"."ACCOUNTDEPLOYMENTLINKS" exists. but then when it proceeds it fails with ORA-00942: table or view does not exist
使用IMPDP可能有什么问题?