达梦dba_segments指定表名查询到的大小都包含哪些数据( 二 )

(六)创建包含LOB字段的表SQL> create table test02(id number,name varchar2(10),content clob);SQL> select owner,segment_name,bytes,blocks,extents,initial_extent from dba_segments where owner='SYSDBA' and segment_name='TEST02';OWNER SEGMENT_NAME BYTES BLOCKS EXTENTS INITIAL_EXTENT------ ------------ -------------------- -------------------- -------------------- --------------------SYSDBA TEST02 4194304 128 4 1048576

推荐阅读