Re: How to remove unrecoverable datafile?

I think this file contain rollback segment. I had same problems some day ago.
I have to do the following:

1. Database shutdown
2. INIT.ORA -> _CORRUPTED_ROLLBACK_SEGMENT=(name)
3. Database open
4. DROP ROLLBACK SEGMENT name;
5. DROP TABLESPACE name INCLUDING CONTENTS;

It's work correctly.

By Balazs

Andy Hardy wrote in message <01bddc61$be8e30d0$c70c400a_at_cms_bssup>...
>Hi,
>
>I have a datafile which is shown as requiring recovery. I cannot recover as
>the required archive log is missing. This is not important as the datafile
>contains no tables, etc.
>
>I've tried an 'offline drop' of the datafile, which produces no error but
>the file continues to be shown as part of the system and requiring
>recovery.
>
>I'm running Oracle 7.3 NT.
>
>Any ideas?
>
>Andy
Received on Thu Sep 10 1998 - 21:18:44 CDT