Thanks. USER_JOIN_IND_COLUMNS is what we will look at. Hemant --- Michael Möller <m2@xxxxxxxx> wrote: > > > Hemant K Chitale wrote: > > > > > However, we find that we are unable to get the BMJI definitions > out, either by > > querying USER_INDEXES or USER_IND_COLUMNS or using > DBMS_METADATA.GET_DDL > > ALL/DBA/USER_JOIN_IND_COLUMNS describes the join conditions of > bitmap join indexes > to which you have access. > > Dont know about the failure of DBMS_METADATA. > > And sorry - I didnt test the above, so I'm just quoting from memory, > aided by the > manual. They have both been known to be wrong before ;-) > > M-square > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > Hemant K Chitale http://hkchital.tripod.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------