cd $ORACLE_HOME/bin strings oracle Stephane Faroult RoughSea Ltd <http://www.roughsea.com> Konagora <http://www.konagora.com> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> On 04/15/2011 07:26 PM, Paresh Yadav wrote:
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