Export tables in SQL mode with BLOB fields

Torque

Member
Hello.

It is possible to export tables in SQL mode with BLOB fields in them if that tables are empty or BLOB fields in that tables are NULL?
I tried to make export but PL/SQL Developer says: "Table SOMETABLE contains one or more BLOB columns. Cannot export in SQL format, use PL/SQL Developer format instead."
I can't use that format because I need a SQL script, so I have deleted all rows in my tables, which contains BLOB data but it's won't work.

Thanks.
 
You can execute a query without the BLOB field on the table in the SQL Window and press the "Export Query Results" button to export in SQL format.

The Export Tables function will not allow you to export a table with a BLOB field in SQL format, regardless of the contents.
 
Back
Top