Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Control Chars in Filename

Re: Control Chars in Filename

From: Joel Garry <joel-garry_at_home.com>
Date: 1 Nov 2002 16:39:23 -0800
Message-ID: <91884734.0211011639.783082c9@posting.google.com>


Billy Verreynne <vslabs_at_onwe.co.za> wrote in message news:<apteib$aiq$2_at_ctb-nnrp2.saix.net>...
> srivenu wrote:
>
> > One note of Caution !
> > You cannot drop a datafile from an Oracle database.
> > You may face a problem soon.
>
> That should be the other way around. You drop a datafile because there is
> already a problem. :-)

Of course, on unix you can drop and rm the file, but because Oracle still has it open it still exists even though ls doesn't see it, so you recreate the file and run out of room... exact effect is version dependent. Be well aware of your gigs!

jg

--
@home.com is bogus.
panic: ifree: freeing free inodes...
Received on Fri Nov 01 2002 - 18:39:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US