使用如下語法
其中STORE AS 修改LOB segment段名字的方法
當分區包括LOB時候
alter table move partition lob () store as ( tablespace )
具體參考
SQL> CREATE TABLE lobtab (
recid NUMBER(
lobcol CLOB )
LOB (lobcol) STORE AS (TABLESPACE USERS)
TABLESPACE USERS;
Table created
SQL> desc lobtab
Name Null? Type
RECID NUMBER(
LOBCOL CLOB
SQL> select index_name
INDEX_NAME TABLESPACE_NAME
INDEX_TYPE
SYS_IL
LOB
LOB Index必須和LOB Segment在一個表空間中
SQL> select table_name
LOBTAB LOBCOL
SYS_LOB
SQL> select rowid from lobtab;
ROWID
AAAdJRACiAAAACqAAA 《
移動LOB Segment
SQL> ALTER TABLE lobtab MOVE LOB (lobcol) STORE AS lobseg (TABLESPACE TOOLS);
Table altered
SQL> select rowid from lobtab;
ROWID
AAAdKeACjAAAABqAAA <
SQL> select index_name
INDEX_NAME TABLESPACE_NAME
INDEX_TYPE
SYS_IL
LOB
沒有發現LOBSEG
SQL> SELECT segment_name
SEGMENT_NAME
SEGMENT_TYPE TABLESPACE_NAME
LOBTAB
TABLE USERS
SQL> select table_name
LOBTAB LOBCOL
SYS_LOB
From:http://tw.wingwit.com/Article/program/Oracle/201311/18121.html