Home » RDBMS Server » Server Utilities » LogMiner fatal trouble (BLOB)
icon8.gif  LogMiner fatal trouble (BLOB) [message #170461] Wed, 03 May 2006 23:23
hofline
Messages: 2
Registered: August 2005
Junior Member
Hi..

I'm try to get DML from oracle archivelog, when I insert an image that contain about 2k bytes of information the DML for this is:

insert into T (image) value (EMPTY_LOB());
update T set image = HEXTORAW('.........');

This is a trouble. This is a large DML that exceed the 4000 bytes and when I try to execute this I get the PL/SQL: ORA-01704: string literal too long error.

Any suggestion please???
Previous Topic: Export from 9i, import into 7? Any chance?
Next Topic: How to write a control file to concatenate or add fileds (sql Loader)
Goto Forum:
  


Current Time: Sat Jun 29 09:19:00 CDT 2024