You can also use my rev_eng.rev_views packaged procedure to reproduce the
DDL for the view. It's downloadable for free from my web site. The longest
LONG string SQL*Plus will display is 32K:
SET LONG 32767
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Christopher Beck wrote in message
<36690e47.28725434_at_inet16.us.oracle.com>...
>On Thu, 03 Dec 1998 21:27:12 GMT, emmguyot_at_altavista.net wrote:
>
>>
>>
>>In order to modifiy a view, I need to get back to text that was used to
create
>>the view. With it, I could modify the view.
>>
>>I found a table, something like dba_views, but I can't see the whole text.
>
>
>You need to set long to a big number so all the text in that column is
>displayed.
>
>try:
>
>SQL> set long 1000000
>
>SQL> select text from all_views where view_name = 'MY_VIEW'
> 2 and owner = 'CHRIS';
>
>
>hope this helps.
>
>
>chris.
>
>
>
>>
>>Thanks for you help
>>
>>-----------------------------------------------------------------------
>>--------------------->>>> Emmanuel Guyot <<<<--------------------------
>>8 Rue des Montées | Phone : [33] (0)2 38 56 42 72
>>45100 Orléans | Email : emmguyot_at_altavista.net
>>
>>-----------== Posted via Deja News, The Discussion Network ==----------
>>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>--
>Chirstopher Beck
>Oracle Corporation
>clbeck_at_us.oracle.com
>Reston, VA.
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
Received on Thu Dec 03 1998 - 16:18:13 CST
