SQL> conn scott/tiger
已连接。
SQL> create table TEST_BLOB
  2  (
  3    FILE_NAME  VARCHAR2(25),
  4    FILE_BIN     BLOB,
  5    FILE_BIN2    BLOB
  6  );

表已创建。

SQL> select T.owner,T.segment_name,T.segment_type from dba_segments t
  2  where t.segment_name like 'SYS_%'
  3  AND T.owner='SCOTT';

OWNER                          SEGMENT_NAME                                 SEGMENT_TYPE
---------------------- ---------------------------------------------------------- ------------------
SCOTT         SYS_IL0000025785C00002$$                        LOBINDEX
SCOTT         SYS_IL0000025842C00002$$                        LOBINDEX                     
SCOTT         SYS_IL0000025842C00003$$                        LOBINDEX
SCOTT         SYS_LOB0000025785C00002$$                     LOBSEGMENT
SCOTT         SYS_LOB0000025842C00002$$                     LOBSEGMENT
SCOTT         SYS_LOB0000025842C00003$$                     LOBSEGMENT

6 rows selected

SQL> DROP TABLE TEST_BLOB;

表已丢弃。

SQL> select T.owner,T.segment_name,T.segment_type from dba_segments t
  2  where t.segment_name like 'SYS_%'
  3  AND T.owner='SCOTT'
  4  /

OWNER                          SEGMENT_NAME                                 SEGMENT_TYPE
---------------------- ---------------------------------------------------------- ------------------
SCOTT         SYS_IL0000025785C00002$$                        LOBINDEX
SCOTT         SYS_LOB0000025785C00002$$                     LOBSEGMENT