Re: How to delete datafile when the database is running on the NT

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 Tue Feb 09 1999 - 14:46:55 CST