help on sync LOBs

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 1
Joined: Wed 26 Oct 2011 10:13

help on sync LOBs

Post by fracarro » Wed 26 Oct 2011 10:29

Hi all! I'm using dbForge Data Compare for Oracle on 10g and it's very good!
I have just a problem when i try to synchronize a table with inside LOBs files.
The error is:
Additional information: Error: ORA-06550: line 3652, column 22:
PLS-00123: program too large (Diana nodes)

Seem that it's happend only with file over 1Mb, there are some oracle
parameter to modify to allow data compare to sucessfully complete this


Devart Team
Posts: 307
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Wed 26 Oct 2011 13:56

Please specify the full version of your Oracle servers for Source and Target.
If you can, please send us DDL of your table with LOB files, that causes the error during synchronization.
You can try to synchronize tables with large LOB files using the file:
for this you need to turn the "Synchronize LOBs via files" option on.

Post Reply