From: kumar <ctkumar@pacific.net.sg>
Subject: Re: Maximum Tablespace
Date: 2000/08/08
Message-ID: <398FABE6.900A34B9@pacific.net.sg>#1/1
Content-Transfer-Encoding: 7bit
References: <3987C006.AE60A8D2@forward-hk.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Subscriber of Pacific Internet 
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle,comp.database.oracle,comp.databases.oracle.server,comp.databases.oracle.tools


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