RE: How to get rid off file permanently?

2001-04-13 Thread Tim Sawmiller
Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion? [EMAIL PROTECTED] 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

RE: How to get rid off file permanently?

2001-04-13 Thread Gene Sais
You shouldn't joke like that :). There are some real new newbies on this list who will follow exactly what you say. Gene [EMAIL PROTECTED] 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

RE: How to get rid off file permanently?

2001-04-13 Thread Glenn Travis
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 [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk

RE: How to get rid off file permanently?

2001-04-13 Thread Gene Sais
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 [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /"

RE: How to get rid off file permanently?

2001-04-13 Thread Kimberly Smith
deserve whatever happens to their systems... My two cents -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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

RE: How to get rid off file permanently?

2001-04-13 Thread Gogala, Mladen
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

RE: How to get rid off file permanently?

2001-04-13 Thread Eric D. Pierce
delicious. :) On 13 Apr 2001, at 13:40, Gogala, Mladen scribbled with alacrity and cogency: ... As a DBA and a gentleman I can not but take pride in helping people to stop making mistakes. next: ... John Leo on CSPAN. As you may recall, he is the columnist from "U.S. News

RE: How to get rid off file permanently?

2001-04-13 Thread Rachel Carmichael
Eric, Are you feeling alright? This is possibly the shortest, most succinct answer I have ever seen you post! :) Rachel From: "Eric D. Pierce" Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: RE: How to get rid off file permanently? Date: Fri, 13 A

RE: How to get rid off file permanently?

2001-04-12 Thread udaycb
try recreating the control file . -Original Message- Oracle 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

RE: How to get rid off file permanently?

2001-04-12 Thread Vadim Gorbounov
Hi, Andrea , You HAVE to drop and create tablespace. Regards, Vadim Gorbounov Oracle dba -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

RE: How to get rid off file permanently?

2001-04-12 Thread Miller, Jay
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

RE: How to get rid off file permanently?

2001-04-12 Thread Smith, Ron 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

RE: How to get rid off file permanently?

2001-04-12 Thread Winnie_Liu
No, you simply cannot drop a datafile from the tablespace. You will need to drop the whole tablespace and rebuild it. Winnie "udaycb" [EMAIL PROTECTED]@fatcity.com on 04/12/2001 11:48:56 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of

RE: How to get rid off file permanently?

2001-04-12 Thread Gogala, Mladen
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