FreeLists / oracle-l / Re: database_properties not in dictionary

["Vitalis Jerome" <vitalisman@xxxxxxxxx>]

As Yasin suggested, have a look at the view code; it selects 'DICTIONARY'
among others, but not any '%DATABASE_PROPERTIES%'.

On 12/1/06, Sinardy Xing <oracle.rdbms@xxxxxxxxx> wrote:
> Well how come dictionary in dictionary?
>
> SQL> select table_name from dictionary where table_name like '%DICT%';
>
> TABLE_NAME
> ------------------------------
> DICTIONARY
> DICT_COLUMNS
> DICT
> GV$LOGMNR_DICTIONARY
> V$LOGMNR_DICTIONARY
>
>
>
>
> On 12/1/06, Yasin Baskan <yasin.baskan@xxxxxxxxxxxxxxxx> wrote:
> >
> >  If you look at the text of the view DICTIONARY you can see that
> > database_properties does not match the predicates there. It is not
> > considered a dictionary table or view.
> >
> >
> >
> > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > *On Behalf Of *Sinardy Xing
> > *Sent:* Friday, December 01, 2006 5:56 AM
> > *To:* oracle-l
> > *Subject:* database_properties not in dictionary
> >
> >
> >
> > Hi all,
> >
> >
> >
> > Do you know why database properties not listed in the dictionary?
> >
> >
> >
> >
> >
> >
> >  SQL> select owner, object_type from dba_objects where object_name like
> > '%DATABASE_PROPERTIES%';
> >
> > OWNER                          OBJECT_TYPE
> > ------------------------------ -------------------
> > SYS                            VIEW
> > PUBLIC                         SYNONYM
> >
> > SQL> select * from dict where table_name  like '%DATABASE_PROPERTIES%';
> >
> > no rows selected
> >
> > SQL> c/dict/dictionary
> >   1* select * from dictionary where table_name  like
> > '%DATABASE_PROPERTIES%'
> > SQL> /
> >
> > no rows selected
> >
> > SQL>  select owner, object_type from dba_objects where object_name like
> > '%DATABASE_PROPERTIES%';
> >
> > OWNER                          OBJECT_TYPE
> > ------------------------------ -------------------
> > SYS                            VIEW
> > PUBLIC                         SYNONYM
> >
> > SQL> select * from dict where table_name  like '%DATABASE_PROPERTIES%';
> >
> > no rows selected
> >
> >
> > --
> > regards,
> >
> > Sinardy
> >
> >
> > Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma
> > ozel ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu
> > mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve
> > para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten
> > sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz,
> > yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi
> > derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer
> > alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan
> > garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis
> > olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz
> > sorumlu tutulamaz.
> >  This message and the files attached to it are under the privacy
> > liability in accordance with the Banking Law and confidential to the use of
> > the individual or entity to whom they are addressed. This message cannot be
> > copied, disclosed or sold monetary consideration for any purpose. If you are
> > not the intended recipient of this message, you should not copy, distribute,
> > disclose or forward the information that exists in the content and in the
> > attachments of this message; please notify the sender immediately and delete
> > all copies of this message. Our Bank does not warrant the accuracy,
> > integrity and currency of the information transmitted with this message.
> > This message has been detected for all known computer viruses thence our
> > Bank is not liable for the occurrence of any system corruption caused by
> > this message
> >
>
>
>
> --
> regards,
>
> Sinardy