In the control pnael, close all the Oracle services using that instance (at
leaste OracleServiceSID and OracleStartSID).
Yannick Gagnon, ift.a.
DBA
Jonathan Lewis wrote in message
<918593323.23580.0.nnrp-12.9e984b29_at_news.demon.co.uk>...
>Try
> alter system checkpoint global;
>This tends to work on Unix systems.
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>
>Dong Tang wrote in message ...
>>
>>I am running Oracle 8.0 on NT 4.0. I just dropped a tablespace, and I want
>>to delete the datafiles in the tablespace. But I get a sharing violation.
>It
>>seems database engine still keep those file open even the whole table
space
>>was already dropped.
>>
>>How do I delete datafiles when the database is running?
>
>
>
>
Received on Thu Feb 11 1999 - 05:11:46 CST
