下面是各查询出来的结果:
SQL> select * from user_tables where table_name='WFD061';
TABLE_NAME TABLESPACE_NAME CLUSTER_NAME
------------------------------ ------------------------------ ------------------------------
PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
--------- --------- --------- --------- -------------- ----------- ----------- -----------
PCT_INCREASE FREELISTS FREELIST_GROUPS B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
------------ --------- --------------- - --------- --------- ------------ --------- ---------
AVG_ROW_LEN DEGREE INSTANCES CACHE TABLE_LO
----------- --------------------- --------------------- ----------- --------
WFD061 HL
10 40 1 255 10240 637075456 1 121
50 1 1 N 0 0 0
0 1 1 N ENABLED
SQL> select * from dba_ts_quotas where user='HLZB';
没有查到记录
SQL> select * from user_segments where segment_name='WFD061';
SEGMENT_NAME SEGMENT_TYPE
--------------------------------------------------------------------------------- -----------------
TABLESPACE_NAME BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ --------- --------- --------- -------------- ----------- -----------
MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS
----------- ------------ --------- ---------------
WFD061 TABLE
HL 1.274E+09 622180 28 10240 637075456 1
121 50 1 1
请各位指教!