Re: Resizing Raw Devices

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/03/01
Message-ID: <6ddkn1$c5c$1@hermes.is.co.za>#1/1

John P. Higgins wrote in message <34F8E479.20CA_at_deere.com>...
>I use raw devices for my tablespaces. As a tablespace fills up, I have
>been adding aditional raw devices.
>
>I know it is possible to expand a raw device using the HP-UX Logical
>Volume Manager (LVM). If I do this, can I use the Oracle
>ALTER DATABASE DATAFILE _____ RESIZE ____ command? Does this woek for
>increases? Decreases?

AFAIK it is not possible to resize an Oracle datafile that is raw device on Unix (well, it's not possible on the hardware/Unix we run on). You will need to drop the datafile (and tablespace) and then re-create it.

regards,
Billy Received on Sun Mar 01 1998 - 00:00:00 CST