01:43:34 rodman@RODMAN>create table test(tupian clob);
Table created.
01:44:33 rodman@RODMAN>insert into test values('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1 row created.
01:45:30 rodman@RODMAN>commit;
Commit complete.
01:45:33 rodman@RODMAN>SELECT A.TABLE_NAME,
01:45:41 2 A.COLUMN_NAME,
01:45:41 3 B.SEGMENT_NAME,
01:45:41 4 B.SEGMENT_TYPE,
01:45:41 5 B.TABLESPACE_NAME,
01:45:41 6 B.BYTES / 1024 / 1024,
01:45:41 7 B.BLOCKS,
01:45:41 8 B.EXTENTS
01:45:41 9 FROM USER_LOBS A, USER_SEGMENTS B
01:45:41 10 WHERE A.SEGMENT_NAME = B.SEGMENT_NAME
01:45:41 11 ORDER BY B.BYTES DESC;
TABLE_NAME
------------------------------
COLUMN_NAME
----------------------------------------------------------------------------------------------------
SEGMENT_NAME SEGMENT_TYPE
--------------------------------------------------------------------------------- ------------------
TABLESPACE_NAME B.BYTES/1024/1024 BLOCKS EXTENTS
------------------------------ ----------------- ---------- ----------
TEST
TUPIAN
SYS_LOB0000081646C00001$$ LOBSEGMENT
USERS
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30491527/viewspace-2062694/,如需转载,请注明出处,否则将追究法律责任。