At 09:36 AM 5/20/2008, you wrote:
Is there an easy way to undelete 1700 rows of data from a table of
33,000 rows?
Marc,
You can restore deleted rows in a table using R:SCOPE.
R:BASE marks a row as deleted by making its row size
a negative number.
To restore a deleted row in R:Scope, you basically
remove the negative and return the row size to positive.
If you have many rows to restore in a table, you can use
R:SCOPE's repeat feature after holding down the [Insert]
key to move through the table restoring rows as it goes.
When you undelete a row that has LOB data, the LOB data
is not restored. The LOB column is set to NULL as soon
as the row is deleted, and the blocks from File 4 are
added to the free block list. You might be able to find
and export the LOB data by examining the LOB file and
then exporting data from the free block list.
The above would require than you use R:Scope "before" a
PACK or RELOAD is issued. After a PACK or RLOAD, the
deleted data would be unrecoverable from these database
files.
Also, if you restore delete rows, you will need to
rebuild the indexes for the table.
John
