Re: Selecting from oracle internal tables

You can get a list of those fixed tables by issuing the query

select name from v$fixed_table;

If you query v$fixed_view_definiton you can see how the views are constructed and figure out what the columns in the x$tables contain.

These internal tables are not documented for us DBAs because their contents are formatted in the v$, dba, all, user views in a more meaningful way.

segoro_at_my-dejanews.com wrote:
: Hi everyone!
: WHO Knows how Can I obtain
: a LiST of oracle intenal tables with columns and maybe descriptions!
: I mean Tables named like 'X$%' and other.
: for Example x$kzsro x$kglpn ...
: Thanks in advance!
: Segoro.

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- Received on Sat Oct 31 1998 - 15:45:05 CST