Re: HELP! deleted system database file :(

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 2 Feb 2001 13:42:39 GMT
Message-ID: <3A7AB94F.B6A4F231@edcmail.cr.usgs.gov>

> ALTER DATABASE CREATE DATAFILE 'yoursystem.dbf
> as '/fullpath/yoursystem.pdf'

Will this work? It seems to me that this will just create the datafile with nothing in it. Since this is the system tablespace, none of the data dictionary tables (like SYS.SOURCE$) will be in this tablespace. The poster will have to recover from a previous backup.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Feb 02 2001 - 07:42:39 CST