Re: Where is v$sqltext
Date: 1996/05/07
Message-ID: <4mntro$v8_at_ins3.coned.com>#1/1
Not true. v$sqltext is in catalog.sql. I am on HP-Ux, Oracle rdbms 7.2.3.
Rajiv Tandon <rajiv.tandon_at_bridge.bellsouth.com> wrote:
>Apparently this is a minor slip-up they've made in building the data dictionary.
>Start looking at the SQL scripts provided in $ORACLE_HOME/rdbms/admin. Look
>particularly at catalog.sql (right near the top) and utlmontr.sql script.
>The catalog.sql (followed by catproc.sql) are the main proponents in building your
>database. The catalog.sql misses the v_$sqltext view when they build the FAMILY "FIXED"
>VIRTUAL VIEWS.
>Originally came the dynamic performance/runtime v$views (without the underscores).
>Then they added v_$views pointing to them. And v_$sqltext got missed out !!!
>Hope this helped.
>Rajiv Tandon
Utrankas_at_coned.com (Sameer Utrankar) Received on Tue May 07 1996 - 00:00:00 CEST