Lyuda;
1. Create a new tablespace for the indexes on a seperate drive. Make sure
you do this with a much more reasonable datafile size. (Watch it here ....
maybe they did the big size because they were running out of possible files
-- see the max_datafiles parm on the Create Database command)
2. Rebuild the indexes over into the new tablespace. Make sure your
initial paramater fits in the initial size of the data files.
3. Drop your old Index Tablespace.
As for your ALTER DATABASE DATAFILE .... RESIZE ... goes; thats what happens
when you use all your space. I would suggest at some point to take an
outage and reorg that tablespace containing the table as well to get its
files down in to a resonably managed size.
-----Original Message-----
Sent: Thursday, August 02, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
