Re: Newbie: Deleted Datafiles!

Assuming the instance is down:
startup mount
alter database datafile '/....' offline drop; ... (repeat until all *deleted* datafiles are dropped) alter database open;

Paul Bennett wrote:

> I'm probably up the creek without a paddle here, but I thought I'd give
> it a shot...
>
> On Oracle 7.3.4 running on AIX 4.3.2, the physical files for some
> tablespaces have been erased. There is no backup. Data loss is not a
> problem, as they didn't have anything useful in them, but I'm not able
> to drop the tablespaces.
>
> I know I'm doing it out of sequence, but I was of the impression that
> they'd already been dropped. I only found out they hadn't when I tried
> to create them again and got told that they already existed.
>
> Can anybody help out with a "quick fix"? My current thought is to nuke
> the whole instance, as it's not a big job to recreate it just yet.
>
> If you have a better plan, please let me know.
>
> TIA,
>
> ---
> Pb
> My opinions are my own and should not be taken as
> representing any other group or entity.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 20 2000 - 13:19:10 CDT