Re: Maximum Tablespace

Hi,

Please check the OS File Size limitations.

Rayfil Cheung wrote:

> 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
Received on Tue Aug 08 2000 - 00:00:00 CEST