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: Autoextend option of tablesapce in oracle is not extending tablespace size automaticlly

Re: Autoextend option of tablesapce in oracle is not extending tablespace size automaticlly

From: koert54 <nospam_at_spam.com>
Date: Mon, 05 Jul 2004 12:14:23 GMT
Message-ID: <zCbGc.19079130$Of.3164039@news.easynews.com>


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

Original text of this message

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