Probably most DBA's have done that once in their career, while 'trash &
burn' old databases... I don't have the textbook here, but I think bring
the tablespaces offline immediate, then drop them.
"Paul Bennett" <spacey845_at_my-deja.com> wrote in message
news:8spi44$2vk$1_at_nnrp1.deja.com...
> 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 Sun Oct 22 2000 - 17:10:00 CDT
