datapump跨数据库迁移数据时，提示”ORA-39002: invalid operation”错误

ORA-38818

[oracle@testos:/home/oracle]$ oerr ora 38818
38818, 00000, "illegal reference to editioned object %s.%s"
// *Cause:  An attempt was made to violate the rule "A noneditioned object
//          may not depend on an editioned object."
// *Action: Either make this object editioned; or do not make the illegal
//          reference.
[oracle@testos:/home/oracle]$

ORA-38818 iilegal reference to editioned object a.bbb

背景

数据库12.1

场景：
db 中2个用户： a和b。

目标：用户a要访问b中的视图，而且已经能够在a中通过 select * from b.bview查询到数据

此时想 在a中建同义词 create synonym bview for b.bview; 失败，报错 ORA-38818 iilegal reference to editioned object a.bbb

原因&解决

b用户启用了版本控制 (editions enabled)，而a没有启用。

故只需要对a同样启用版本控制:

alter user a enable editions;

参考

ORA-38818: illegal reference to editioned object APPS.PARAMOBJECT while creating nested table. — oracle-tech

ORA-39002: invalid operation during datapump TZ version Difference

最近有个datapump跨数据库迁移数据时，提示”ORA-39002: invalid operation”错误， 排除过目录文件权限和语法兼容问题，后来发现是目标库的Timezone Version低于源库的TZ version. 需要升级目标库的TZ VERSION，这里简单记录该问题.

$ impdp xxx@xxx directory=xxx  dumpfile=xxx.dmp logfile=xxx.log table_exists_action=replace 
Import: Release 18.0.0.0.0 - Production on Tue Mar 22 17:40:58 2022
Version 18.3.0.0.0

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

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operati