Re: I have deleted a datafile.

What about when the tablaspace has a rollback segment ?? I try DROP TABLESPACE NAME INCLUDING CONTENTS but i have the
ORA-01548: active rollback segment 'RB_DATA' found, terminate dropping tablespae error...

the rollback segment 'RB_DATA' doesn't exist, i try the fllowin commands but without succes!!!   drop rollback segment rb_data;

any help are very appreciated.
haithem

At 09:56 95-11-07 +0530, you wrote:
>Use the following commands in SQLDBA
>
>STARTUP NOMOUNT
>ALTER DATABASE MOUNT
>ALTER DATABASE DATAFILE '<specify the file name and path>' OFFLINE DROP
>ALTER DATABASE OPEN
>
>Once the Database is OPEN,
>DROP TABLESPACE TEMP (which had the file).
>
>Hemant K Chitale
>BTW : Setting a Tablespace Storage Parameter wrongly cannot result in
>an error of the type "not enought space for log file".
>
>You might try the above for both the NEW and the TEMP Tablespace.
>I hope you had NO Objects in TEMP !
>
>
>> From: Zhang Lei <zhangl_at_PRLSUN1.IA.AC.CN>
>> Subject: I have deleted a datafile.
>> X-To: ORACLE-L_at_ccvm.sunysb.edu
>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>
>> Status: RO
>>
>> Hi, friends,
>> What a fool I am! I set a tablespace's storage arguments wrongly. That is to
>> say, I set the 'initial' parameter to 100M. Then when I shutdown and
restart,
>> I was told that there was not enough space for log file, and the instance
> didn't
>> startup. Then I tried to delete some files from the disk. I deleted a temp
> data
>> file which had served as temp file for a tablespace. Then tradgedy happened!
>> I cannot get the database started any more! And I cannot get the deleted file
>> restored. What shall I do?
>> -desperate Lei Zhang
>>
>

   _______       ___________  __
   \      \     /          / / /             Haithem Abdelkefi
    \      \   /          / / /              Vigie Informatique 2000 Inc.
     \      \ /__________/ / /               6433, chemin St-Francois,
      \      \   _________/ /                St-Laurent, Quebec
       \      \  \         /                 H4S 1B6
        \      \  \       /
         \      \  \     /                   email: haithem_at_vigie.qc.ca
          \      \  \   /                    Tel: (514)956-9138
           \______\  \_/                     Fax: (514)331-2743