Re: huge datafiles/need help

Lyuda,
You didn't say if you have other disk space available or not. If you do I would create the index/indexes tablespace/s on different drives then drop them from the original location. After you get breathing room you can reorg the database to a more comfortable setup. When you have removed the indexes you will have to exp/imp the tables to free up the fragments in the tablespace. Good Luck.
ROR mª¿ªm

>>> lhoska_at_calibresys.com 08/02/01 03:45PM >>>
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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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).