Dropped Datafile

From: Subramaniam, Lakshmi (L.) <lsubrama_at_ford.com>
Date: Fri, 19 May 2000 09:16:49 -0400
Message-Id: <10502.106088@fatcity.com>

A trainee inadvertantly deleted a datafile from the OS 'immediately' after creating it. Everything seems okay for now except once in a while the following error shows up while creating schema objects:

	ORA-00376: file 13 cannot be read at this time
	ORA-01110: data file 13: '<OS datafile path>'

Query on dba_data_files shows the datafile to exist even after issuing the 'ALTER database datafile ... offline DROP' command.

Full database export works fine. Logical backups every day - Development server.

Any suggestions to clean up the database apart from cold backup - dropping tablespace - dropping datafiles at OS level - recreating tablespace and doing a table level import for the objects that earlier existed in that tablespace.

Thanks in advance Received on Fri May 19 2000 - 08:16:49 CDT