select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_segments where
owner='SCHEMA_NAME';
OR
select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_extents where
owner='SCHEMA_NAME'
-Sunnet
"YIF "
<oracledba-ezmlms
hield-x57640856.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
05/11/2006 04:52
PM Subject
Mail Size: 4239 Size of Schema
Our Ref
Your Ref
Dear All
how can we get the size of schema.
regards
///\\
(@ @)
+--oOO--(_)--Ooo--+
|Yoseph I Fahed|
+-----------------+
|__|__|
|| ||
ooO Ooo
--------
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 originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************
************************************************************
HSBC Software Development (India) Pvt Ltd
HSBC Center Riverside,West Avenue ,
25 B Kalyani Nagar Pune 411 006 INDIA
Telephone: +91 20 26683000
Fax: +91 20 26681030
************************************************************
-----------------------------------------
*******************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.
Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
*******************************************************************
Oracle LazyDBA home page