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!

problem with create tablespace statement

REDO LOGOct 14 2012 — edited Oct 14 2012

Hi all
I am trying to create a tablespace using the following statement :

create tablespace INDEX01 datafile 'E:\oracle\product\10.2.0\oradata\orcl\index01.dbf' size 1M
extent management local uniform size 4k
autoextend on next 500K maxsize 2M;

but oracle returns the following error:

Error starting at line 1 in command:
create tablespace INDEX01 datafile 'E:\oracle\product\10.2.0\oradata\orcl\index01.dbf' size 1M
extent management local uniform size 4k
autoextend on next 500K maxsize 2M
Error at Command Line:2 Column:39
Error report:
SQL Error: ORA-02180: invalid option for CREATE TABLESPACE
02180. 00000 -  "invalid option for CREATE TABLESPACE"
*Cause:    An invalid option appeared.
*Action:   Specify one of the valid options
           ONLINE, OFFLINE, FORCE, RETENTION.

I really can't see where I got in wrong!
thanks for help
(oracle 10.0.2.0, windows xp sp3)

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2012

Added on Oct 14 2012

#general-database-discussions

1 comment

1,089 views