oracle lob basicfile,【求助帖】关于blob和clob的一些错误

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

LZ又来求助各位大神了。是这样的，由于此前不小心删掉了一个带有blob和clob类型的表，现在需要重建。有这个表以前导出的存档。存档语句如下：

CREATE TABLE "TPL"."SY_PART"

(

"ID" NUMBER NOT NULL ENABLE,

"SYSTEMPOPEDOM" VARCHAR2(4000 BYTE),

"FUNCTIONCODE" NUMBER(32,0) DEFAULT (-1),

"CREATEPEOPLE" VARCHAR2(200 BYTE),

"CREATETIME" DATE DEFAULT (SYSDATE),

"DEPLEVEL" VARCHAR2(50 BYTE) DEFAULT 0,

"TABLENAME" CLOB,

"MODELNAME" CLOB,

"SOURCENAME" CLOB,

"ANALYSISNAME" CLOB,

"TABLENAME1" CLOB,

"CXNAME" CLOB,

"CLNAME" CLOB,

"LS" NUMBER DEFAULT 0,

"LS_START_DATE" DATE,

"LS_END_DATE" DATE,

"SYSTEMTYPE" VARCHAR2(50 BYTE) DEFAULT 'syjk'

)

SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS 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 "SYJK_SYSTEM" LOB

(

"TABLENAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"MODELNAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"SOURCENAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"ANALYSISNAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"TABLENAME1"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"CXNAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

)

LOB

(

"CLNAME"

)

STORE AS BASICFILE

(

TABLESPACE "SYJK_SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE 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)

) ;

后面的备注语句和索引语句就不放上来了。

然后直接语句建立或者执行.sql文件的时候就会在

SEGMENT CREATION IMMEDIATE这里出现红线报ORA-00922选项缺失或无效。之后将SEGMENT那一段去掉只保留TABLESPACE "SYJK_SYSTEM"之后的。然后会报错说无效的storage选项，出现红线的位置就是每个lob后面STORE AS BASICFILE之后。也试过用PLSQL直接编辑表插入字段选择blob，但是会提示字段名重复，然后给字段名加了双引号也不行。后面blob的内容里如果添加了sql文档里的这些语句，会报错说缺失左括号。。现在依旧一头雾水中，此前也没有用过clob和blob，求大神帮助。