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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Tablespace ORA-02180

user3636719Mar 22 2012 — edited Mar 22 2012

I am trying to create tablespace, but I am keep getting below error.

CREATE TABLESPACE GOODS_LOB_TS DATAFILE  '/FREE/rdbm4/oracle/FREE/datafiles/goods_lob_ts_01.dbf' 500M AUTOEXTEND OFF 
EXTENT MANAGEMENT LOCAL;

Error

Error starting at line 1 in command:
CREATE TABLESPACE GOODS_LOB_TS DATAFILE  '/FREE/rdbm4/oracle/FREE/datafiles/goods_lob_ts_01.dbf' 500M AUTOEXTEND OFF 
EXTENT MANAGEMENT LOCAL
Error at Command Line:1 Column:99
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.

CREATE TABLESPACE GOODS_LOB_TS DATAFILE  '/FREE/rdbm4/oracle/FREE/datafiles/goods_lob_ts_01.dbf' 500M;

Error

Error starting at line 1 in command:
CREATE TABLESPACE GOODS_LOB_TS DATAFILE  '/FREE/rdbm4/oracle/FREE/datafiles/goods_lob_ts_01.dbf' 500M AUTOEXTEND OFF 
EXTENT MANAGEMENT LOCAL
Error at Command Line:1 Column:99
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 am not sure what wrong I am going here.

This post has been answered by Srini Chavali-Oracle on Mar 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2012

Added on Mar 22 2012

#general-database-discussions

7 comments

13,871 views