Re: Oracle Names query wildcard

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in news:tom79kfh2f6bd_at_news.demon.nl:

>
> "Robert Fazio" <dbabob_at_yahoo.nospam.com> wrote in message
> news:Xns910ABD705FAC2dbabobyahoocom_at_24.12.106.199...

>> I know that I am just missing something little, but I am trying the
>> following and not getting anywhere.
>>
>> NAMESCTL> query *

Closer to what I wanted, but not quite. dump_tnsnames gave me what I was looking for, but only when I got it to work. If you are not the root domain it doesn't work (bug). list_objects was also a better match to what I was looking for. But thanks, it was still very useful information.

What I am really trying to do is query sort of show me all dbnames that are like some pattern.

query *QAS* cname.smd

To show me all databases that are QA databases. Our instance naming scheme is XXXYYYNN XXX - Company YYY -(DEV,QAS,PRD,TRN,TST...) NN is the project number.

So if I wanted to find all databases for project 02 I could do it.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com