Re: How in the world do you delete a data file?
Date: Wed, 2 Mar 94 17:15:21 -0500
Message-ID: <9403021715.PN12733_at_LL.MIT.EDU>
In article <2l2fqk$dm9_at_hpux.rz.uni-jena.de> okk_at_rz.uni-jena.de (Khamsonh Khounlivong) writes:
>From: okk_at_rz.uni-jena.de (Khamsonh Khounlivong)
>Subject: Re: How in the world do you delete a data file?
>Date: 2 Mar 1994 16:45:08 GMT
>Jeff Kopmanis (jeffk_at_garnet.msen.com) wrote:
>: Why is it that there isn't a way to elegantly get rid of unneeded/unwanted
>: datafiles? Isn't zapping the tablespace a little severe? Who was the moron
>: who thought up a great way to ADD space, but forgot the commands to get rid
>: of it?! That's like designing a car that only goes forward....what happens
>: when you park it in a driveway?
>I've got the same problem. Finding my files in V$DATAFILE, but no connection
>to tablespaces and it seems to be no way to remove this unneeded files from
>oracle system. I've heart about this problem often - but no solution.
>If anybody can help us, please do it.
>(you can remove files hard, but that's not the way to clean oracel ...
>*grummel* %^\ )
>Kh. M. Khounlivong
Why don't you guys be real men and go in as SYS and delete V$datafile rows you don't need, or if that is a view find the underlining table and just delete the rows.
-jf Received on Wed Mar 02 1994 - 23:15:21 CET