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

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 17 Nov 2000 16:44:00 -0500
Message-Id: <10683.122429@fatcity.com>

Cherie,
 If you modify the listed script you will get the objects in the dba_segmen= ts.

=3D=3D=3D=3D=3D=3Dstart=3D=3D=3D=3D=3D=3D Rem listing of the table space information. File c:\glcsql\tsdetail.sql

	set feedback off;
	set pagesize 256;
	set head on;

column today noprint new_value xtoday
Select to_char(sysdate,'MM/DD/YYYY" " HH24:MI:SS') today from dual;

TTITLE LEFT '--------------------------------------------------------------=
--------------------------------' -

SKIP CENTER xtoday -
SKIP CENTER 'TABLESPACE SEGMENTS DETAIL LISTING BY SEGMENT TYPE, =

TABLESPACE, SEGMENT NAME' -
SKIP LEFT   '--------------------------------------------------------------=
--------------------------------'=20
		column segment_name format a30
		column segment_type format a6 heading TYPE
		column tablespace_name format a25 heading 'TS NAME'
		column extents format 999 heading EXTS
		column bytes format 9,999,999,999
		column blocks format 9,999,999
		select segment_name,segment_type,tablespace_name,
		extents,bytes,blocks from dba_segments
		where tablespace_name !=3D 'SYSTEM'
		and owner not in ('SYS','SYSTEM')
		order by segment_type,tablespace_name,segment_name;
	=09

=3D=3D=3D=3D=3Dend=3D=3D=3D=3D=3D

ROR m=AA=BF=AAm

>>> Cherie_Machler_at_gelco.com 11/17/00 04:17PM >>>
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

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author:=20
  INET: Cherie_Machler_at_gelco.com=20

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:44:00 CST