This discussion is archived
5 Replies Latest reply: Oct 7, 2012 2:12 PM by phaeus RSS

Create Tablespace based on ASM diskgroup

scottjhn Newbie
Currently Being Moderated
Oracle 11g r2.

create tablespace test
datafile '+DATA' size 32G
maxsize unlimited
autoextend on
extent management local AUTOALLOCATE
segment space management auto;


--error:

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.


What could be wrong?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points