修复破坏的DUAL表
1.没有重新启库 建表 create table sys.dual( dummy varchar2(1) )tablespace system; 授权 grant select on sys.dual to public with grant option; 插入关键数据 insert into dual values('X'); 善后 查看相关SYS下的失效对象,并重新编译 select object_name,owner,object_type from dba_objects where status='INVALID' @?/rdbms/admin/utlrp.sql 2.重新起库 设置参数 replication_dependency_tracking 为false alter system set replication_dependency_tracking=false scope=spfile; 建表 create table sys.dual( dummy varchar2(1) )tablespace system; 授权 grant select on sys.dual to public with grant option; 插入关键数据 insert into dual values('X'); 设置参数 alter system set replication_dependency_tracking=true scope=spfile; 善后 查看相关SYS下的失效对象,并重新编译 select object_name,owner,object_type from dba_objects where status='INVALID' @?/rdbms/admin/utlrp.sql
新闻名称:修复破坏的DUAL表
文章起源:http://scyanting.com/article/ppoggc.html