Re: Maximum Tablespace

As oracle type the shell command "ulimit", that's will give you the maximum size for the user (in number of blocks).

You can increase this value with the same command.

--
Have a nice day
Michel


Rayfil Cheung <rayfil_at_forward-hk.com> a écrit dans le message : 3987C006.AE60A8D2_at_forward-hk.com...


> I want to create an Oracle 8.0.6 tablespace of initial size of 1G and


> atmost grow to 10G under AIX 4.3.2. It has error.  What is the maximun

> size of a tablespace?  How can I extend the tables of an user to 2 or

> more tablespace?  Thank you.

>

> create tablespace rgem

>    datafile '/gemdata/oradata/rgem/rgem.dat' size 1024M reuse

>    autoextend on next 100M maxsize 10240M;

>

> ERROR at line 1:

> ORA-01119: error in creating database file

> '/gemdata/oradata/rgem/rgem.dat'

> ORA-27039: create file failed, file size limit reached

> Additional information: 1

>

>