SQL Language (MOSC)

MOSC Banner

Create statments with storage clauses not being applied

edited Jul 5, 2014 5:00AM in SQL Language (MOSC) 4 commentsAnswered

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center