Create Tablespace based on ASM diskgroup
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?