vault验证导出领域对象导入新的shecma是否生效

环境:
OS:Centos 7
DB:11.2.0.4
hxl100为受保护的schema


1.导出:
expdp system/oracle directory=data_pump_dir dumpfile=hxl100.dmp schemas='(hxl100)'

2.导入相同的库,不同的schema
impdp system/oracle directory=data_pump_dir dumpfile=hxl100.dmp remap_schema=hxl100:hxl200

3.验证valut在新的shecma是否生效
SQL> connect / as sysdba
Connected.
SQL> select * from hxl100.tb_100;
select * from hxl100.tb_100
*
ERROR at line 1:
ORA-01031: insufficient privileges

数据导入到另外一个schema后,新的schema数据不受保护
SQL> select * from hxl200.tb_100;

ID NAME
---------- --------------------------------
1 name1
2 name2

原文地址:https://www.cnblogs.com/hxlasky/p/15419749.html