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_at_yapikredi.com.tr> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 01 2006 - 02:07:38 CST
