select sum(BYTES/1024/1024) as TOTAL_GIG
from dba_segments where OWNER=UPPER('&SCHEMA_NAME');
Regards
John Fak
Oracle DBA
_____________________
Accenture Workforce Solutions
mobile: +44 (0)778 655 1214
landline: +44 (0)207 844 6981
Octel : (46981)
mailto:john.[Email address protected]
-----Original Message-----
From: j [mailto:oracledba-ezmlmshield-x6152234.[Email address protected]
Sent: 14 September 2004 13:02
To: LazyDBA Discussion
Subject: space occupied by a schema.
Dear All,
How can one find the total space occupied by a particular schema? (say a
user "ABC")
Jay
DISCLAIMER: The information contained in this message is intended only
and solely for the addressed individual or entity indicated in this
message and for the exclusive use of the said addressed individual or
entity indicated in this message (or responsible for delivery
of the message to such person) and may contain legally privileged and
confidential information belonging to Tata Consultancy Services Limited.
It must not be printed, read, copied, disclosed, forwarded, distributed
or used (in whatsoever manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly
prohibited and may constitute unlawful act and can possibly attract
legal action, civil and/or criminal.
The contents of this message need not necessarily reflect or endorse the
views of Tata Consultancy Services Limited
on any subject matter. Any action taken or omitted to be taken based on
this message is entirely at your risk and neither the originator of this
message nor Tata Consultancy Services Limited takes any responsibility
or liability towards the same. Opinions, conclusions and any other
information contained in this message that do not relate to the official
business of Tata Consultancy Services Limited shall be understood as
neither given nor endorsed by Tata Consultancy Services Limited or any
affiliate of Tata Consultancy Services Limited. If you have received
this message in error,
you should destroy this message and may please notify the sender by
e-mail. Thank you.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Oracle LazyDBA home page