DROP TABLESPACE, datafiles still locked...

From: Syltrem <syltrem_at_videotron.ca>
Date: Fri, 24 Nov 2000 16:36:44 -0500
Message-ID: <j3BT5.3633$SJ2.99401@weber.videotron.net>

Hi!

I am on OpenVMS 7.2-1, Oracle 8.0.5.1

Why is my datafile locked agter I offline the tablespace? Why is it locked after i DROp the tablespace?

It was eventually closed (I tried again after 5 minutes) and I could delete it, but why doesn<y Oracle close files when a tablespace is offlined?

Thanks!

create tablespace test datafile 'ORA_DB03$DISQUE:[DGSITEST.RENCS]test.dbf' size 1m;

Tablespace created.

SQL> alter tablespace test offline ;

Tablespace altered.

SQL> $ delete ORA_DB03$DISQUE:[DGSITEST.RENCS]test.dbf;;

%DELETE-W-FILNOTDEL, error deleting

ORA_DB03$DISQUE:[DGSITEST.RENCS]TEST.DBF;1 -RMS-E-FLK, file currently locked by another user

SQL> drop tablespace test;

Tablespace dropped.

SQL> $ delete ORA_DB03$DISQUE:[DGSITEST.RENCS]test.dbf;;

%DELETE-W-FILNOTDEL, error deleting

ORA_DB03$DISQUE:[DGSITEST.RENCS]TEST.DBF;1 -RMS-E-FLK, file currently locked by another user Received on Fri Nov 24 2000 - 15:36:44 CST