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

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'