lob类型表move操作
ALTER TABLE TEST20180101 MOVE
TABLESPACE SSMPORTAL_IDX
LOB (CONTENT) STORE AS
(TABLESPACE SSMPORTAL_IDX);
--------------------------------------------------------------------------------------------------------------------------------------------
How To Use ALTER TABLE ... MOVE To Shrink A Table (Including BASICFILE / SECUREFILE LOBs) ( Doc ID 1396120.1 )
ALTER TABLE MOVE LOB makes indexes unusable on the parent table ( Doc ID 1228324.1 )
==>
E.g.:
SQL>ALTER TABLE table_name MOVE LOB(lob_columnname) STORE AS (TABLESPACE new_tablespace_name);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31401608/viewspace-2149641/ ，如需转载，请注明出处，否则将追究法律责任。
