Hi all,

I made an error and deleted some row in a table, restoring all the database
from my ontape archive is not a valid solution and i must find a way to
restore this only table. Is there any solution ?

My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4)

Any help would be appreciated :-)

Fred

Do you have everyone table stored in a different dbspace?

if yes then you can just restore that dbspace

if not then your option will be to restore the archive to a speerate
machine/instance and then unload the table your require



Bob wrote:
> Hi all,
>
> I made an error and deleted some row in a table, restoring all the database
> from my ontape archive is not a valid solution and i must find a way to
> restore this only table. Is there any solution ?
>
> My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4)
>
> Any help would be appreciated :-)
>
> Fred

Bob < wrote:
> Hi all,
>
> I made an error and deleted some row in a table, restoring all the database
> from my ontape archive is not a valid solution and i must find a way to
> restore this only table. Is there any solution ?
>
> My system is IDS 7.31 Workgroup edition running on Win 2000 (sp4)
>
> Any help would be appreciated :-)
>
> Fred
>
>


You can restore to a different system... all you'll need is space.
Besides this there was a version of archecker that in restricted cases
would allow you to recover a table from a backup. Check the IIUG (
http://www.iiug.org ) to find if this is publicly available. This tool
was the base of the new and supported tool to do it (which is only
available on 10.X).

Regards.