using logminer to retrive CLOB data

[GERPAT]

I need to undo a delete that was executed on a table that has field with a datatype CLOB. When I use logminer to retrieve the "undo" transaction it, logminer tells me that CLOBS are not supported. The insert statement looks like this:

insert into article (title,teaser,body,)
values ('Latest News','Visit out latest news section','Unsupported Type')

If logminer does not mine CLOB data how can I undo this transaction?

 

[HimanB]

Hi,
If you have some old backup export file then try to retrive the same from it.

Regards
Himanshu

 

[GERPAT]

Thanks for getting back to me.

I do an export of the database every night, unfortunetly this transaction happened prior to the last export so the export contains the bad transaction.

As far as you know is it impossible to retrieve clob data from the archive logs.

Regards

Gerard

 

[HimanB]

GERPAT,
What version of Oracle you are using?
I have found that LOB's are supported In logminer of Oracle 9.2.x.

Regards
Himanshu

 

[GERPAT]

I'm using an Oracle 8.1.7.0.0 database. There must be some way of retrieving CLOB data from an archive_redo_log, otherwise standby databases wouldn't work with CLOB data, which I find hard to believe.

 

[GERPAT]

forgot ot mention: the database is sitting on a Windows 2000 server.

 

[HimanB]

Gerpat,
Check out following URLs:

http://www.databasejournal.com/features/oracle/article.php/10893_2203041_3

https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10734/rcmflash.htm

http://www-rohan.sdsu.edu/doc/oracle/server803/A54642_01/ch_lob.htm

https://cwisdb.cc.kuleuven.ac.be/ora10doc/appdev.101/b10795/adfns_fl.htm

HTH
Regards
Himanshu