RE: Table Size

[Goulet, Dick]

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