Hello All,
Thanks for your responses. I am listing the query, if any one else wants to use the
query :-
SELECT t.tablespace_name, t.initial_extent,
t.next_extent, t.min_extents, t.max_extents,
t.pct_increase, status, contents, nvl(sum(extents),0)
FROM sys.dba_tablespaces t, sys.dba_segments s
where t.tablespace_name=s.tablespace_name(+)
group by t.tablespace_name, t.initial_extent,t.next_extent,
t.min_extents, t.max_extents,
t.pct_increase, status, contents
/
Rgds,
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
