Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

New DB Create Tablespace

736874Jan 8 2013 — edited Jan 8 2013
I'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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2013
Added on Jan 8 2013
6 comments
2,722 views