Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: X$Tables Info

Re: X$Tables Info

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Mon, 11 Dec 2000 21:24 -0600
Message-Id: <10707.124277@fatcity.com>


Hi,
The v$fixed_table contains info about the x$ tables

select * from V$FIXED_TABLE
where name like 'X%' ;

will give you a list of X$ tables.

HTH
               shreepad Received on Mon Dec 11 2000 - 21:24:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US