Why the data_length of NCLOB is 4K only?
Hi all,
I have created a table and it has 1 column with data type is NCLOB as bellow:
CREATE TABLE "TEST"."TABLE_01"
(
"ID_NUMBER" NUMBER(19,0),
"DKENKNMWK0" NCLOB DEFAULT ON NULL ' ' NOT NULL ENABLE,
PRIMARY KEY ("ID_NUMBER") ENABLE
) ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "MYTBS"
PCTTHRESHOLD 20 OVERFLOW
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "MYTBS"
LOB ("DKENKNMWK0") STORE AS SECUREFILE (