文章出处:http://blog.itpub.net/post/2553/16664
Connected to Oracle8i Enterprise Edition Release 8.1.7.0.0
Connected as scott
SQL> desc test_blob;
Name Type Nullable Default Comments
FILE_NAME VARCHAR2(25) Y
FILE_BIN BLOB Y
FILE_BIN2 BLOB Y
SQL>
SQL> select t.segment_name, t.segment_type, t.tablespace_name
2 from sys.user_segments t
3 where t.segment_name like 'SYS_%'
4 /
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
SYS_IL0000025842C00003$$ LOBINDEX SYSTEM
SYS_IL0000025842C00002$$ LOBINDEX SYSTEM
SYS_LOB0000025842C00002$$ LOBSEGMENT SYSTEM
SYS_LOB0000025842C00003$$ LOBSEGMENT SYSTEM
6 rows selected
SQL> alter table test_blob move tablespace tools;
Table altered
SQL>
SQL> select t.segment_name, t.segment_type, t.tablespace_name
2 from sys.user_segments t
3 where t.segment_name like 'SYS_%'
4 /
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
SYS_IL0000025842C00003$$ LOBINDEX SYSTEM
SYS_IL0000025842C00002$$ LOBINDEX SYSTEM
SYS_LOB0000025842C00002$$ LOBSEGMENT SYSTEM
SYS_LOB0000025842C00003$$ LOBSEGMENT SYSTEM
6 rows selected
SQL> select t.segment_name, t.segment_type, t.tablespace_name
2 from sys.user_segments t
3 where t.segment_name like 'TEST_BLOB';
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
TEST_BLOB TABLE TOOLS
SQL> alter table test_blob move tablespace SYSTEM;
Table altered
SQL> ALTER TABLE test_blob MOVE
2 TABLESPACE tools
3 LOB (FILE_BIN,FILE_BIN2) STORE AS
4 (TABLESPACE tools);
Table altered
SQL> select t.segment_name, t.segment_type, t.tablespace_name
2 from sys.user_segments t
3 where t.segment_name like 'SYS_%';
SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
SYS_IL0000025842C00003$$ LOBINDEX TOOLS
SYS_IL0000025842C00002$$ LOBINDEX TOOLS
SYS_LOB0000025842C00002$$ LOBSEGMENT TOOLS
SYS_LOB0000025842C00003$$ LOBSEGMENT TOOLS
6 rows selected