Complete (more than 4000 char) text of fixed view definition?

From: Paresh Yadav <yparesh_at_gmail.com>
Date: Fri, 15 Apr 2011 13:26:20 -0400
Message-ID: <BANLkTinCOCptc3_f1pLGGAB9WmJ-pD9JXQ_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 15 2011 - 12:26:20 CDT

This message: [ Message body ]
Next message: john scott: "RMAN RESTORE TO A DIFFERENT SID"
Previous message: Rodd Holman: "Re: OT: Anyone using Kindle for Oracle Docs and/or other tech docs?"
Next in thread: Michael Dinh: "RE: Complete (more than 4000 char) text of fixed view definition?"
Reply: Michael Dinh: "RE: Complete (more than 4000 char) text of fixed view definition?"
Reply: Stephane Faroult: "Re: Complete (more than 4000 char) text of fixed view definition?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message