CODEWITHSUNDEEP
plsqlplsqldeveloper
user1233906
user1233906

Reputation: 41

Cannot export table from PL/SQL developer having a column datatype as CLOB

I need to export table having a column datatype as clob.

I need to have inserts scripts for that table. But I get following error when I try to export the table from PL/SQL developer

Table XYZ contains one or more CLOB columns. Cannot export in SQL format, use PL/SQL Developer format instead

Is there a way I can export tables with CLOB column datatype using plain SQL scripts?

Upvotes: 4

Views: 5218

Answers (2)

breq
breq

Reputation: 25526

I know that topic is old but maybe someone in future need this: When You export a blob field use this

dbms_lob.substr( blob_field , 3999, 1) blob_field

where blob_field is your cblob

Upvotes: 1

user2006555
user2006555

Reputation: 1

As of the latestest version of SQLDeveloper you can try out xml export, this at least worked for me for CLOBs.

Upvotes: 0

Related Questions