Re: Datafile/Tablespace creation....

[JOE TESTA]

Lisa, if the db dont recognize it(and you should be able to do a alter system checkpoint and see the date/time on the file didnt get updated), then you can remove it safely.   hth, joe   >>> [EMAIL PROTECTED] 08/13/01 04:31PM >>> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).