Re: Complete (more than 4000 char) text of fixed view definition?
- From: Paresh Yadav <yparesh@xxxxxxxxx>
- To: Michael Dinh <mdinh@xxxxxxxxx>
- Date: Fri, 15 Apr 2011 13:55:11 -0400
Thanks Michael.
dba_views does not have definition of fixed views.
------------------------------------
select * from dba_views
WHERE VIEW_NAME IN ( 'GV$SESSTAT', 'GV$SESSION')
------------------------------------
no rows selected
Paresh
On Fri, Apr 15, 2011 at 1:42 PM, Michael Dinh <mdinh@xxxxxxxxx> wrote:
> What about using text from dba_views?
>
>
>
> select * from dba_views where text_length>4000
>
>
>
> Michael Dinh
>
>
>
> NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under applicable
> laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH
> INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING,
> AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI
> CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT
> NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS
> MESSAGE. If the reader of this email (and attachments) is not the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. Please notify the
> sender of the error and delete the e-mail you received. Thank you.
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Paresh Yadav
> *Sent:* Friday, April 15, 2011 10:26 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Complete (more than 4000 char) text of fixed view definition?
>
>
>
> Hi,
>
>
>
> How can I get complete (more than 4000 char) text of fixed view definition?
>
> SQL> desc v$fixed_view_definition
>
>
>
> Name Null? Type
>
> ----------------------------------------- -------- -----------------------
>
>
>
> VIEW_NAME VARCHAR2(30)
>
> VIEW_DEFINITION *VARCHAR2(4000)*
>
>
> --
> Thanks
> Paresh
>
>
--
Thanks
Paresh
416-688-1003
Other related posts:
