Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBA Help

DBA Help

From: Kevin Chin <kchin_at_isc.mds.lmco.com>
Date: Wed, 17 Jun 1998 16:32:28 -0400
Message-ID: <Pine.SOL.3.96.980617163046.5199A-100000@blackbird>


Hello,

Was wondering knew what to do if they accidentally deleted the dbf file in a unix system without having dropped the tablespace yet? There is no data lost, but just to clean out the system so the oracle tables no longer have a recollection of that tablespace. I goofed and deleted the file first before dropping the tablespace. I understand it should be the other way around. Thanks for any input.

Kevin Chin


Kevin A. Chin				E-Mail:	kevin.chin_at_lmco.com
Lockheed Martin Corporation		Voice:	(703) 293-4134
Integrated Solutions Center (ISC)	FAX:	(703) 293-4110
3201 Jermantown Road
Fairfax, VA 22030
Received on Wed Jun 17 1998 - 15:32:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US