Login  Register

Upgrade ebsR12.1.3 database 11.1.0.7 to 11.2.0.4

Posted by satish on Nov 04, 2022; 9:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-ebsR12-1-3-database-11-1-0-7-to-11-2-0-4-tp11198.html

Hi erman,

Need your help.

Pre upgrade step:

Clean Up Duplicate Objects Owned by SYS and
SYSTEM schema


Refer > Note 1030426.6 How to Clean Up
Duplicate Objects Owned by SYS and SYSTEM schema

SQL> column obiect name format a30
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';


OBJECT_NAME



AQ$_SCHEDULES
AQ$_SCHEDULES_PRIMARY
DBMS_REPCAT_AUTH DBMS_REPCAT_AUTH
WPG_DOCLOAD WPG_DOCLOAD
6 rows selected.


OBJECT_TYPE

TABLE
INDEX
PACKAGE
PACKAGE BODY
PACKAGE
PACKAGE BODY


Our concern is can we take backup and drop the below package owned by system before upgrade?

WPG_DOCLOAD

PACKAGE
PACKAGE BODY


Thank you