Shulou(Shulou.com)06/01 Report--

1. Create table sys.dual (dummy varchar2 (1)) tablespace system; authorization grant select on sys.dual to public with grant option without rebooting the library Insert critical data insert into dual values ('X'); then look at the invalid objects under the relevant SYS and recompile select object_name,owner,object_type from dba_objects where status='INVALID' @? / rdbms/admin/utlrp.sql2. Restart the library setting parameter replication_dependency_tracking to create a table for false alter system set replication_dependency_tracking=false scope=spfile; create table sys.dual (dummy varchar2 (1)) tablespace system; authorization grant select on sys.dual to public with grant option Insert critical data insert into dual values ('X'); set parameter alter system set replication_dependency_tracking=true scope=spfile After that, check the invalid objects under the relevant SYS, and recompile select object_name,owner,object_type from dba_objects where status='INVALID' @? / rdbms/admin/utlrp.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.