Re: huge datafiles/need help

Hi Lyuda

This is not a nice situation to bee in, but the god new is that oracle can help you since you are using version 8.1.6 !
You can use the "ALTER INDEX <index-name> REBUILD TABLESPACE <new-tablespace_name>;" to move the index to a new tablespace and this can even be don online with "ALTER INDEX <index-name> REBUILD ONLINE TABLESPACE <new-tablespace_name>;" BUT then you have to look out for bug 1475310 that should be fixed in 8.1.7.

lhoska_at_calibresys.com wrote:

> Hi List,
> I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask
> me who created such a file because I don't know. I am trying to rescue the
> database that has multiple problems. Something you've never seen before.
> Bye the way, did anyone ever run a test how much stuff you can put on your
> disc before it dyes? Well, yesterday I found a disc which was 99.07 % full.
> Anyway...
> The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce
> the size of the datafiles by using 'alter database datafile ... resize...';.
> That tablespace contains 32 indexes. Some of them are as large as 600 -800
> M. I need to develop a plan of attack.
> My options are:
> 1) drop and recreate the indexes;
> 2) rebuild the indexes in different tablespace/tablespaces;
> 3) export/import indexes or may be even tablespace all at once.
>
> Is there anyone who has done something similar before?
> All suggestions are greatly appreciated. That database is screaming for
> help!!
> It running Oracle 8.1.6 on NT.
>
> Lyuda Hoska
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: lhoska_at_calibresys.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).

--
Regards

Peter Gram

Miracle A/S
http://MiracleAS.dk
Tel: +45 2527 7107