Load up a sample set of rows, check the number of
blocks used (analyze, then look at user_tables), then
multiply by the expected increase factor
hth
connor
- Hamid Alavi <hamid.alavi_at_QUOVADX.COM> wrote: >
Dear List,
>
> I have a question regarding Table size, I want to
> put the small size of
> tables in a small TBS,But don't know the size of
> table do I have to
> calculate the size for which period, Assume we want
> to keep the data for 5
> years so do I have to calculate the size of table
> for 5 years then decide if
> this table is in the range of small table or NOT.
> Any Idea appreciate.
> Thanks,
>
> Hamid Alavi
>
> Office : 818-737-0526
> Cell phone : 818-416-5095
>
>
>
>
>
>
> ======================= Confidentiality Statement
> =======================
> The information contained in this message and any
> attachments is
> intended only for the use of the individual or
> entity to which it is
> addressed, and may contain information that is
> PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If
> you have received
> this message in error, you are prohibited from
> copying, distributing, or
> using the information. Please contact the sender
> immediately by return
> e-mail and delete the original message from your
> system.
> ===================== End Confidentiality Statement
> =====================
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.com
>
> 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: ListGuru_at_fatcity.com (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).
>
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
Received on Thu Mar 20 2003 - 21:03:37 CST