Re: 'drop tablespace' produces a file/table lock??

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 25 Jul 2003 20:32:09 +0300
Message-ID: <3f216998_1@news.estpak.ee>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F212BF7.945ECC7C_at_remove_spam.peasland.com...
> I know it's not "fixed" in 9i. I recall that not too long ago, I was
> teaching a Backup & Recovery class using 9i on Windows. We were in
> SQL*Plus and we had just shutdown the database. While still in SQL*Plus,
> I tried to delete a database datafile to simulate a harddisk failure. I
> could not delete the datafile until I exited SQL*Plus. And no database
> was running....

When I was maintaining some 8.0's on NT4 I even had to restart the Oracle service in order to be able to delete a datafile... But 8.0 and NT4 are history anyway... (for lucky ones ;)

Tanel. Received on Fri Jul 25 2003 - 12:32:09 CDT