策略错误 ORA-28100:policy function schema FMIS1600 is invalid.
来源:互联网 发布:青岛住房保障网通知书 编辑:程序博客网 时间:2024/05/16 06:30
OGG相关(oracle报错)
目标端数据库imp之后,查询相关表,报 ORA-28100。这是以为再源端有vpd策略,在目标端删除这些策略即可。
ALL_POLICIES 策略信息 DBA_,USER_
ALL_POLICY_GROUPS 定义的策略组 DBA_,USER_
1、查询策略
查看所有用户的策略: select OBJECT_OWNER,OBJECT_NAME,POLICY_GROUP,POLICY_NAME from dba_policies;
查看登录用户的策略:
SQL>select OBJECT_NAME,POLICY_GROUP,POLICY_NAME from user_policies;
OBJECT_NAME POLICY_GROUP
------------------------------ ------------------------------
POLICY_NAME
------------------------------
ENMO_EMP SYS_DEFAULT
POLICY_ENMO_EMP
2、删除策略
SQL>exec dbms_rls.drop_grouped_policy('AWEN','ENMO_EMP','SYS_DEFAULT','POLICY_ENMO_EMP');
PL/SQL procedure successfully completed.
下面的过程是网上一位同学写的,可以快速删除所有策略。 (有些情况可能不可用)
declare
-- Local variables here
i integer;
str_schema varchar2(20) := 'ods_yyjc_buf';
str_obj_name varchar2(20) ;
str_group_name varchar2(20);
str_policy_name varchar2(30);
begin
-- Test statements here
for item in (select * from all_policies) loop
str_obj_name := item.object_name;
str_group_name := item.policy_group;
str_policy_name := item.policy_name;
dbms_rls.drop_grouped_policy(object_schema => str_schema,object_name => str_obj_name,
policy_group => str_group_name,policy_name => str_policy_name);
end loop;
for item in (select * from ALL_POLICY_GROUPS) loop
str_obj_name := item.object_name;
str_group_name := item.policy_group;
str_policy_name := str_schema;
dbms_rls.delete_policy_group(str_schema,str_obj_name,str_group_name);
end loop;
end;
0 0
- 策略错误 ORA-28100:policy function schema FMIS1600 is invalid.
- ORA-06575: Package or function SPLIT is in an invalid state
- 关于错误: 'encoding' is an invalid keyword argument for this function的错误原因之一
- ORA-00911: invalid character错误
- IOS Implicit declaration of function 'xxxxxx ' is invalid in C99 错误
- 编译错误解决:implicit declaration of function 'close' is invalid in C99
- xcode9报 Implicit declaration of function 'require' is invalid in c99 的错误
- ORA-01185 logfile group number *** is invalid
- 错误"ORA-04091: table is mutating, trigger/function may not see it"的原因以及解决办法
- cuda invalid device function 错误改正
- ORA-30553: The function is not deterministic
- Oracle-ORA-01722 invalid number错误
- ORA-00904:invalid identifier错误的解决办法
- Oracle-ORA-01722 invalid number 错误
- ORA-600错误[kkoipt:invalid join method]
- ORA-01722 invalid number错误原理解
- Oracle-ORA-01722 invalid number错误
- Oracle-ORA-01722 invalid number错误
- 让fstream支持中文路径
- Fiddler-手机测试抓包利器
- sencha touch《SenchaCmd编译项目》
- 中断向量表 和 中断描述符 关系
- JAVA并发编程学习笔记之AQS源码分析(超时、中断与其他)
- 策略错误 ORA-28100:policy function schema FMIS1600 is invalid.
- 如何备份MySql的数据库
- 内存问题
- System.ICloneable接口
- Android4.0中Contacts通话记录界面剖析(源码)
- 2014市场预测:大数据让企业获得“大智能”
- 线段树模板(二)——成段更新 + POJ 3468 A Simple Problem with Integers
- python下的MySQLdb使用
- PC浏览器安装vlc插件播放rtsp流