I am trying to get the script of view using all_views , text column. When I spool it in sqlplus, I am not able to get the
full text in the file.

Am I missing something.

Also, as the text is a long column , I am not able to do a
substr or any operation on that. I am sure there is a
round about way to do this.

Can somebody help me on this.