Please use the below query to check the same.

column object_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’;

 

 

O/P Sample

—————

OBJECT_NAME OBJECT_TYPE
—————————— ——————-
AQ$_SCHEDULES TABLE
AQ$_SCHEDULES_PRIMARY INDEX
DBMS_REPCAT_AUTH PACKAGE
DBMS_REPCAT_AUTH PACKAGE BODY

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search