recover blob from deleted row?
Posted in 2004
Jim Cramer — — source: IIUG Forums & Mailing Lists
Hi,
With IDS 7.31, I accidentally deleted a row from a table. 2 of the
columns are type BYTE and store their data in a blobspace.
Is there a way to extract the row's blob data from my onbar backup ("file"
type backup device). I do not want to restore the dropped row back into
the database, I just want the byte data for the 2 blobs that were in that
row.
Can I use onlog to do this? I can probably find the transaction id, where
the
row was deleted, to use as an onlog display filter.
Would onlog be feasible, or is there some other way to get the data?
Thanks,
Jim Cramer
University of Iowa