Create statments with storage clauses not being applied
I'm having trouble with a Create statement. The STORAGE clause of the LOB CLAUSE doesn't seem to apply when I execute the command. What am I doing wrong?
e.g.,
CREATE TABLE MY_TABLE
(
MY_ID NUMBER(10) NOT NULL,
MY_DATA CHAR(10 BYTE) DEFAULT ' ' NOT NULL
)
LOB (MY_DATA_AREA) STORE AS (
TABLESPACE TBS_01
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
LOGGING
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
));
when I look at the script for resulting the table with toad or SQL Developer I get the following: