Re: 1 Table and its Indexes occupying 30% space of the Database.

By the time you have to worry, you will have retired from the job ;-)

Deepender.Gupta_at_newpower.com wrote:

> Hi All,
>
> I have a table in my database ( size 70GB ) with size of 7GB and it has 13
>
> indexes on it. 5 Indexes are of the size 2 GB and rest are around
>
> 500-800Mb.
>
> Total size of the table and indexes in total is 21GB.
>
> The table size is increasing everyday and every 10-12 days I have to add a
>
> datafile for Index and data tablespace.
>
> I just want to know the precautions I need to take while maintaining this
>
> table. Is oracle 7.3 having restriction on the maximum size of the table.
>
> Kindly give your valuable suggestions.
>
> Thanks in advance,
>
> Deepender Gupta
>
> The New Power Company
> 1 Manhattanville Road
> Purchase, NY 10577
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Deepender.Gupta_at_newpower.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).