I have a sql query like below to check duplicate objects in SYS/SYSTEM before upgrade.
Code: Select all
select OBJECT_NAME, OBJECT_TYPE from
DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from
DBA_OBJECTS where OWNER='SYS') and
OWNER='SYSTEM' and OBJECT_NAME not in
I have a list of large duplicated objects. My question / problem is : how to get rid of the objects? What is the best way to approach this?
Thanks & Regards,