RE: How to get rid off file permanently?

If someone has been given access to root and doesn't know what they are doing, then the sysadmins deserve whatever happens to their systems...

My two cents

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gene Sais
> Sent: Friday, April 13, 2001 9:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to get rid off file permanently?
>
>
> You shouldn't joke like that :). There are some real new newbies
> on this list who will follow exactly what you say.
>
> Gene
>
> >>> MGogala_at_oxhp.com 04/12/01 06:10PM >>>
> Another good way of reclaiming disk space on Unix boxes is to execute "rm
> -rf /"
> as "root". That is an excellent way for saving some money for the disk
> drives!!!!
>
> -----Original Message-----
> Sent: Thursday, April 12, 2001 3:41 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have dropped a datafile a couple of times by taking it offline and then
> dropping it. This was done after I created a new datafile and
> accidentally
> put it in the wrong place, got the allocation wrong or misspelled
> the name.
> You just have to make absolutely sure that the datafile does not
> contain any
> objects.
>
> -----Original Message-----
> Sent: Thursday, April 12, 2001 2:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> You can't just drop a datafile. You need to drop the entire tablespace.
>
> -----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: andreaoracle_at_yahoo.com
>
> 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: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> 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: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> 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: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> 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: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Travis
  INET: c-glenn.travis_at_wcom.com

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