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_at_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: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Lisa R.
Clary INET: lisa_at_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_at_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).
Received on Mon Aug 13 2001 - 14:44:19 CDT
