I’m using Oracle DB and I’m trying to map part of my schema.

I’m using the following query to recieve all views existing in my schema for further analysis:

select * from all_views where owner like '%SCHEMA_NAME%'

The result shows all views’ data including the views’ scripts.

Since the views’ script can be very long – I cna’t export the results for further analysis.

The data type of the column that shows the script is and when trying to export it the result is truncated and I don’t see the FULL view’s script.

Any suggestion how to export the whole result set? Maybe if it’s a memory issue, the solution would be to iterate the result set and export it one by one?