2022-09-07
ORACLE 改LOB字段为NOLOGGING写语句报错
ORACLE 11G,表TB_QSD_ZP有建表语句的部分(从dbms_metadata.get_ddl得到):
TABLESPACE "USERS"
LOB ("CONTENT") STORE AS SECUREFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW
CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES )
现在这个CONTENT字段,想改成NOLOGGING,写语句如下:
alter table XXX.tb_qsd_zp modify LOB("CONTENT" BLOB) STORE AS SECUREFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW
CHUNK 8192 NOCACHE NOLOGGING NOCOMPRESS KEEP_DUPLICATES);
alter table XXX.tb_qsd_zp modify LOB(CONTENT) STORE (NOLOGGING);
alter table XXX.tb_qsd_zp modify LOB("CONTENT") STORE AS SECUREFILE(NOLOGGING);
都报同样错
ERROR at line 1:
ORA-00907: missing right parenthesis
求大师指教!
我来答
添加附件
收藏
分享
问题补充
6条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论







