SQL> select name, type 2 from sys.v_$fixed_table 3 where type = 'TABLE' 4 and rownum < 6 5 / NAME TYPE ------------------------------ ----- X$KQFTA TABLE X$KQFVI TABLE X$KQFVT TABLE X$KQFDT TABLE X$KQFCO TABLE 5 rows selected. SQL>