| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to get rid off file permanently?
Well, if a total newbie is given root access to production machines then my
suggestion will actually help them streamline their operating procedures
and find flaws in their administration principles. Actually, you might say
that if there is a company which has a person of the right mindset to follow
my advice and if that person has root access to production machines, my
advice
will probably help them straighten out their biggest mistake - being in the
business in the first place. As a DBA and a gentleman I can not but take
pride
in helping people to stop making mistakes.
-----Original Message-----
Sent: Friday, April 13, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L
Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion?
>>> 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:
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.
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Fri Apr 13 2001 - 15:48:38 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |