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: Oracle 7.3.3 on AIX 4.2.1 & Raw Devices

Re: Oracle 7.3.3 on AIX 4.2.1 & Raw Devices

From: José Nicolau <jnicolau_at_hotmail.com>
Date: Sun, 22 Nov 1998 18:46:47 +0100
Message-ID: <36584E05.9AA5A90C@hotmail.com>


it's easy:
expand de logical volume with smit, it does not destroy any data on the LV, next alter the parameters of your tablespace (or datafile, I'm not sure now) to AUTOEXTEND ON, and that's all.
When there is need more space the tablespace will grow automaticaly.

Rob wrote:

> I've read in an Oracle Press book that it is possible to expand a raw
> device. We are in the position of having to add space to a tablespace
> currently consisting of one raw device.
>
> Is my only option to ALTER TABLESPACE <tsname> ADD DATAFILE
> '/dev/new_raw_dev' ...
> or can I somehow modify the existing raw device at the O/S Level through the
> logical volume manager?
>
> This may be more of an AIX question than Oracle, but if someone out there
> has the same set-up (AIX) and Oracle 7.3, I'd greatly appreciate any
> insight.
>
> Thanks,
> Rob.
Received on Sun Nov 22 1998 - 11:46:47 CST

Original text of this message

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