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