How to clean up duplicate objects in SYS/SYSTEM

Sometimes we have different errors in the Oracle system because of duplicate objects in SYS/SYSTEM. This can happen as catalog.sql and catproc.sql were mistakenly run while connected as both users. In most cases, the only objects which should exist are those owned by SYS. The output can help determine which objects should be dropped from the SYSTEM schema. The …

How to clean up duplicate objects in SYS/SYSTEM Read More »