Sometimes objects can find their way into the system tablespace when they should be in a difference tablespace. Here’s how to see if there are any of these objects that need moving.

select owner, segment_name from dba_segments
where tablespace_name = 'SYSTEM'
and owner !='SYS'
and owner !='SYSTEM'

How to find out which data is in the the SYSTEM tablespace

Leave a Reply

Your email address will not be published. Required fields are marked *

seventy six − = 68