From JTESTA@longaberger.com Mon, 13 Aug 2001 12:44:19 -0700 From: "JOE TESTA" Date: Mon, 13 Aug 2001 12:44:19 -0700 Subject: Re: Datafile/Tablespace creation.... Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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   >>> lisa@cog.ufl.edu 08/13/01 04:31PM >>>I attempted to create a new tablespace, but did not have db_files set largeenough and so it aborted the tablespace creation (found this in the alertlog). 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 manuallydelete the datafile (at the OS level) without repercussion? Nothingrecognizes the datafile (e.g. select * from dba_data_files, OEM, TOAD).thanks,lc--Lisa R. Clary104 N. Main Street, Suite 600Gainesville, 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@cog.ufl.eduFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).