New DB Create Tablespace
736874Jan 8 2013 — edited Jan 8 2013I'm new to creating a database from the ground up. What did I do wrong? I ran this script in SQLPLUS
create tablespace
MYTBL
datafile
'F:\app\admin\oradata\ARCH\MYTBL01.dbf'
size 1G
blocksize 32K
maxsize unlimited
uniform size 100M
autoextend ON;
I loaded Ora 11g standard and when I try to create a tablespace or a bigfile tablespace I get the following error:
maxsize unlimited
Ora-02180: invalid option for CREATE TABLESPACE
I remove that and get the same error for
autoextend ON
Ora-02180: invalid option for CREATE TABLESPACE
The only way I can create a tablespace is if I strip the script down to:
create tablespace
MYTBL
datafile
'F:\app\admin\oradata\ARCH\MYTBL01.dbf'
size 1G
uniform size 100M;