There is a page about algorithms for shooting yourself in a foot
somewhere on the web (it can be found by starting at www.ugu.com)
but you don't have to do it in public. Scientifically speaking,
if you deleted a database file from the disk, your database is in
so called foobar state and about the only thing you can do is to
perform the tablespace recovery. BTW, how did you get the idea
to call yourself "Andrea Oracle"? Why not "Dan Quayle"?
-----Original Message-----
Sent: Thursday, April 12, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I need to permanently get rid off some files from the
database. I did this:
1. alter database datafile
'/orafs/ora1/oradata/LUCP/users02.dbf' offline drop
2. rm the file from physical directory
After I shutdown and restart the db, I still see the
file in dba_data_files table. So how to tell the
control file that the file is already gone?
Thank you.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
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).
