set lines 80
set long 1000000
select view_name,text from dba_views@doppler where owner='CRA_SNAP'
;
are u looking for this .