RE: How to get rid off file permanently?

2001-04-13 Thread Eric D. Pierce
> 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 Apr 2001 14:00:33 -0800 > > > >de

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? Dat

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 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 foll

RE: How to get rid off file permanently?

2001-04-13 Thread Kimberly Smith
dmins 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

RE: How to get rid off file permanently?

2001-04-13 Thread Gene Sais
le 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:10P

RE: How to get rid off file permanently?

2001-04-13 Thread Glenn Travis
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 > > >>>

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 so

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-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 datafile

RE: How to get rid off file permanently?

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

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 li

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 contain

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 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 da

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 '/orafs/ora1/oradata/LUCP/users0