SQL QUERY TO FIND THE NON SYS OBJECTS IN SYSTEM TABLESPACE

Use this query to identify the objects which are not owned by SYS or SYSTEM user respect to icol$ in system tablespace

select b.owner,
            b.object_name,
            b.object_type,
            b.status
from
sys.icol$ a
inner join dba_objects b on ( a.obj# = b.object_id )
and b.owner not in ('SYS','SYSTEM')
order by 1 desc;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s