Re: How to find the size of a table that is not yet been used?

In article <32a4d1d9.0_at_news1.starnetinc.com>, jitano_at_starnetinc.com (Marco G Chiriboga) wrote:
> Can any one please let me know how to determine with accuracy the size
> of a table that is not yet used. We need to find out if the size is
> correct before hand.
> Regards
> Marco

Check out DBA_SEGMENTS if the table has been created. If it's not then you can add ad storage clause to your "create table" stmt. If you dont add a storage clause then the default storage is used. (see DBA_TABLESPACES)

<PLUG>
There are some good storage scripts on:

   http://www.worldonline.nl/~bytelife
<END of plug>

R. Schierbeek, DBA                         ---|--- 
I'd rather be flying    _____________________ | _____________________
email: bytelife_at_worldonline.nl               (_)