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

Home -> Community -> Mailing Lists -> Oracle-L -> Datafile/Tablespace creation....

Datafile/Tablespace creation....

From: Lisa R. Clary <lisa_at_cog.ufl.edu>
Date: Mon, 13 Aug 2001 12:17:48 -0700
Message-ID: <F001.0036924F.20010813123107@fatcity.com>

I attempted to create a new tablespace, but did not have db_files set large enough and so it aborted the tablespace creation (found this in the alert log). However, some of the process completed as it did create a datafile. Now that I have bumped up the db_files parameter what do can I manually delete the datafile (at the OS level) without repercussion? Nothing recognizes the datafile (e.g. select * from dba_data_files, OEM, TOAD).

thanks,
lc

--
Lisa R. Clary
104 N. Main Street, Suite 600
Gainesville, FL 32601

(352) 392-5198 x 312
(352) 392-8162 (fax)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: lisa_at_cog.ufl.edu 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).
Received on Mon Aug 13 2001 - 14:17:48 CDT

Original text of this message

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