Maximum Tablespace
From: Rayfil Cheung <rayfil_at_forward-hk.com>
Date: 2000/08/02
Message-ID: <3987C006.AE60A8D2_at_forward-hk.com>#1/1
Date: 2000/08/02
Message-ID: <3987C006.AE60A8D2_at_forward-hk.com>#1/1
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'