Repair broken DUAL table

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