Tuesday, April 13, 2010

How to check user objects created in SYSTEM tablespace not owned by SYS user

Query to check objects created in SYSTEM tablespace and not owned by SYS or SYSTEM user.
It is very important not to have user related objects in SYSTEM tablespace.


select owner, segment_name, segment_type
from dba_segments
where tablespace_name = 'SYSTEM'
and owner not in ('SYS','SYSTEM');

No comments:

Post a Comment