dba_extents提示未选定行解决

SQL> conn system/manager
已连接。
SQL> select * from tab24;


C1
----------

qwe

SQL> select * from dba_extents where owner='system' and segment_name='TAB24';


未选定行


SQL> select * from dba_extents where owner='SYSTEM' and segment_name='tab24';


未选定行

SQL> select * from dba_extents where owner='SYSTEM' and segment_name='TAB24';


OWNER
------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
PARTITION_NAME                 SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
 EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS RELATIVE_FNO
---------- ---------- ---------- ---------- ---------- ------------
SYSTEM
TAB24
                               TABLE              SYSTEM
         0          1      88168      65536          8            1

**************************************************************

总结：对象名要大写！