Remove datafile

From: Alianto <alianto_at_mincom.co.id>
Date: Wed, 10 Feb 1999 11:14:56 +0700
Message-ID: <36c106f3@news1.us.ibm.net>

Dear All,

I have tried to remove a datafile in a tablespace, but it didn't come out. I have shutdown dan startup the instance, but it looks same as before. And here the statements that I capture from sqldba :

SQLDBA> select * from v$datafile where status='RECOVER'; FILE# STATUS ENABLED CHECKPOINT BYTES NAME

---------- ------- ---------- ---------- ---------- ------------------------
----
        47 RECOVER READ WRITE          0  415236096 MISSING0047
        48 RECOVER READ WRITE   10109621       4096


/data4/oracle/idxmsf/idxmsf902b.dbf


        51 RECOVER READ WRITE   10497500   37748736

/data5/oracle/tabmsf/tabmsf1xxa.dbf

3 rows selected.

SQLDBA> alter database datafile '/data5/oracle/tabmsf/tabmsf1xxa.dbf' offline drop;
Statement processed.

SQLDBA> commit;
Statement processed.

SQLDBA> select * from v$datafile where status='RECOVER'; FILE# STATUS ENABLED CHECKPOINT BYTES NAME

---------- ------- ---------- ---------- ---------- ------------------------
----
        47 RECOVER READ WRITE          0  415236096 MISSING0047
        48 RECOVER READ WRITE   10109621       4096


/data4/oracle/idxmsf/idxmsf902b.dbf


        51 RECOVER READ WRITE   10497500   37748736

/data5/oracle/tabmsf/tabmsf1xxa.dbf

3 rows selected.
SQLDBA> Comment are welcome.

Regards,
Alianto
alianto_at_mincom.co.id Received on Tue Feb 09 1999 - 22:14:56 CST