0

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?

Improve this question
4
  • 2
    Instead of using the ALL_VIEWS data dictionary view, you could use the API DBMS_METADATA.GET_DDL to get the view definition. Commented Dec 26, 2024 at 13:35
  • 1
    This is a problem with your client software that you're using to do the export, not with the Oracle database. Many clients are perfectly capable of dealing with the long datatype. Very likely your client has some configuration/settings screen where you can tell it how to deal with LOBs and longs. Commented Dec 26, 2024 at 14:55
  • This looks like having issues with column TEXT that is of LONG datatype. Detailed instructions and code to convert LONG datatype into CLOB "on-the-fly" could be found at: ellebaek.wordpress.com/2010/12/06/… Commented Dec 26, 2024 at 18:26
  • There is also LittleFoot's accepted answer at: stackoverflow.com/questions/75977379/… Commented Dec 26, 2024 at 18:32
Related questions
211
Android: why is there no maxHeight for a View?
516
How to export table as CSV with headings on Postgresql?
3
ORACLE SQL DEVELOPER can't see all View
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.