5 Replies Latest reply: Oct 7, 2012 4:12 PM by phaeus RSS

    Create Tablespace based on ASM diskgroup

    scottjhn
      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?