RE: Datafile/Tablespace creation....

Lisa,

yeah, you can either delete the files, or use the REUSE clause in the create tablespace command. the REUSE clause will reuse the existing file if it finds it - if it doesn't find it, it will create it normally.

if you are on NT, you may not be able to delete the file (file is sometimes locked by the Oracle processs - a re-bounce of the database clears this up).

hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, August 13, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).