I'm trying to create dictionary managed tablespace with the
TEMPORARY clause and
TEMPFILE clause of
CREATE TABLESPACE statement. But oracle says I can't use the
DEFAULT STORAGE clause doing that... What is the error here ?
CREATE TABLESPACE myTempTableSpace TEMPFILE '/home/folder/tempfile.dbf' size 1M DEFAULT STORAGE ( INITIAL 1M PCTINCREASE 0 ) TEMPORARY EXTENT MANAGEMENT DICTIONARY;
The error is :
ORA-02180: invalid option for CREATE TABLESPACE