RE: Dropped Datafile

Everything is okay now...just wait until you bump the instance. My suggestion is a good old-fashioned rebuilding of the control files.

Chris Griffith
OCP DBA -----Original Message-----
From: Subramaniam, Lakshmi (L.) [mailto:lsubrama_at_ford.com] Sent: Friday, May 19, 2000 10:28 AM
To: Multiple recipients of list ORACLE-L Subject: Dropped Datafile

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

-- 
Author: Subramaniam, Lakshmi (L.)
  INET: lsubrama_at_ford.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).