I think we can use dbms_space_admin package to get the accurate size of the
table...not the allocated (querying the data dictionary will report the
allocated space...)
Murali.
|---------+---------------------------->
| | "Goulet, Dick" |
| | <[EMAIL PROTECTED]|
| | > |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | .com |
| | |
| | |
| | 10/15/2003 05:24 |
| | PM |
| | Please respond to|
| | ORACLE-L |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: Table Size
|
>--------------------------------------------------------------------------------------------------------------|
Then the easy answer is:
select sum(nvl(vsize(<column_1>),1)+nvl(vsize(<column_2>),1)+......
)/1073741824
from <table_name>;
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Table Size
All the tables already exist and have data.
Thanks a lot for your response,
Rajesh
-----Original Message-----
From: Goulet, Dick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Table Size
Raj,
Does the table already exist & have data or are you looking
for a gestimate?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Table Size
Hi All,
Could somebody help me in finding the actual size of
an oracle table in GB.
TIA,
Rajesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
