Re: Datafile Sharing Violation Windows NT

If you are using 9i

was the datafile empty before you dropped it? were there any constraints on the tables/objects in the tablespace/datafile?

If so maybe you need to do an

DROP TABLESPACE tablespace_name
INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; Also as a tip, do a full backup of datafiles, control files and redo log files before perfomring these tasks

I am not sure if you will be able to reactivate this tablespace without using RMAN or some other tool???

When in doubt check the manual

GOOD LUCK JOHN mark.davey_at_dsl.pipex.com (Mark Davey) wrote in message news:<c994d998.0212030841.185e1f58_at_posting.google.com>...
> Hi,
>
> I have dropped a tablespace and it's associated datafiles from within
> Oracle (i.e. Oracle knows nothing about the datafiles on the drive)
> proved by the following: -
>
> SQL> alter database datafile
> 'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora' offline drop;
> alter database datafile
> 'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora' offline drop
> *
> ERROR at line 1:
> ORA-01516: nonexistent log file, datafile or tempfile
> 'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora'
>
> The database is not production critical so I have re-started the box
> but NT/2000 still reports a 'Sharing violation' when I try to remove
> the datafiles.
>
> Am I missing something, is there somewhere else I should be checking
> within Oracle for the existence of these files?
>
> Thanks in advance
>
> Mark Davey
Received on Thu Dec 12 2002 - 09:56:11 CET