Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control Chars in Filename
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