How to create a LOB Table ?[akadia]

If you plan to store LOB data, together with other data in the same table, then you should store the LOB data in a separate tablespace.

CREATE TABLE news (
id NUMBER(12) NOT NULL,
news NUMBER(12),
picture BLOB DEFAULT empty_blob(),
picturetype VARCHAR2(20)
)
LOB (picture) STORE AS (
TABLESPACE lob
STORAGE (INITIAL 10M NEXT 10M PCTINCREASE 0)
CHUNK 50
PCTVERSION 10
NOCACHE LOGGING

)
PCTFREE 10
PCTUSED 40
INITRANS 2
MAXTRANS 255
TABLESPACE tab
STORAGE (INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1);


请使用浏览器的分享功能分享到微信等