Re: Need a script that finds users objects that are also in system

I am hoping you mean to say that you are looking for a script that will find all objects which are owned by users other than sys and system yet are in the system tablespace.

In that case a simple select from dba_segments would be able to help you :

Select owner,segment_type,segment_name
from dba_segments
where tablespace_name = 'SYSTEM' and
owner not in ( 'SYSTEM', 'SYS')
order by 1,2,3
/

you can try using the following additional enviroment settings as well to format it into something like a report in sqlplus.

col segment_name format a40
set linesize 120 pagesize 24

Allan.
----- Original Message -----
From: <Cherie_Machler_at_gelco.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 17, 2000 5:17 PM
Subject: Need a script that finds users objects that are also in system

> Does anyone have a script that
> will find all the objects that are owned
> by a user that are also owned by system.
>
> Thanks,
>
> Cherie
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 17 2000 - 15:46:01 CST