LOBSEGMENT的系统命名规则是

LOBSEGMENT的系统命名规则是

SYS_LOB(10 digit object_id)C(5 digit col#)$$   表段
SYS_IL(10 digit object_id)C(5 digit col#)$$        索引

 

SQL> select * from (select segment_name,bytes/1024/1024,t.owner,t.segment_type　from dba_segments t where tablespace_name='KETTLE'
  2  order by bytes desc ) where rownum<2
  3  ;
 
SEGMENT_NAME                                                                     BYTES/1024/1024 OWNER                          SEGMENT_TYPE
-------------------------------------------------------------------------------- --------------- ------------------------------ ------------------
SYS_LOB0000072141C00017$$                                                                   1990 KETUSER                        LOBSEGMENT
 

 

SQL> select object_name,status from dba_objects where object_id='0000072141';
 
OBJECT_NAME                                                                      STATUS
-------------------------------------------------------------------------------- -------
LOG_RUNINFO                                                                      VALID

 

SQL> desc ketuser.LOG_RUNINFO
Name           Type          Nullable Default Comments
-------------- ------------- -------- ------- --------
ID_BATCH       NUMBER(38)    Y                        
CHANNEL_ID     VARCHAR2(255) Y                        
TRANSNAME      VARCHAR2(255) Y                        
STATUS         VARCHAR2(15)  Y                        
LINES_READ     NUMBER(38)    Y                        
LINES_WRITTEN  NUMBER(38)    Y                        
LINES_UPDATED  NUMBER(38)    Y                        
LINES_INPUT    NUMBER(38)    Y                        
LINES_OUTPUT   NUMBER(38)    Y                        
LINES_REJECTED NUMBER(38)    Y                        
ERRORS         NUMBER(38)    Y                        
STARTDATE      DATE          Y                        
ENDDATE        DATE          Y                        
LOGDATE        DATE          Y                        
DEPDATE        DATE          Y                        
REPLAYDATE     DATE          Y                        
LOG_FIELD      CLOB          Y 

 

总结：LOBSEGMENT表示的是大字段类型。这里为clob的数据类型

 

 

SYS_LOB(10 digit object_id)C(5 digit col#)$$   表段
SYS_IL(10 digit object_id)C(5 digit col#)$$        索引