Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export a table (as insert) containing a BLOB column

BlueForest85Jun 2 2023 — edited Jun 2 2023

Hello everyone,

I use SQL developer to export several objects (tables, views, functions, sequences….) to import them in another schema.

To do so, I select all tables, right click, export, as insert…., and the same for other objects.

Is it a proper method ?

However, I noticed that for one of my table containing a BLOB column, this column is not exported.

How should I proceed to properly export the table ?

Thank you

This post has been answered by thatJeffSmith-Oracle on Jun 2 2023
Jump to Answer
Comments
Post Details
Added on Jun 2 2023
2 comments
3,552 views