Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Autoextend option of tablesapce in oracle is not extending tablespace size automaticlly
check your ulimit (/etc/security/limits) - if it's a default install ulimit
will be 2097152 blocks or 1GB filesize...
Because Oracle can - it doesn't mean your OS will allow it
cheers,
Kurt
<niraj_2005_at_yahoo.com.sg> wrote in message
news:a2ffe9ad.0407041917.2d4f8900_at_posting.google.com...
> Hi All ,
> Oracle 9i is running on AIX unix box . Initial dbf file size was 1
GB
> with Autoexpand option enabled . Maximum file size was set 32767 to
MB
> with increment 56 K Bytes per extension and File System size is 10
GB.
> I expected once tablespace size will reach to 1GB , it will be
auto
> extended . But unfortunately this is not happening . Looking
forward
> for help from all of you .
>
> Thanks & Warm Regards
> Niraj
Received on Mon Jul 05 2004 - 07:14:23 CDT