Undelete a deleted row
A user on Informix SE 5.x asked whether deleted rows could be recovered from a table that hadn't been touched since the errant DELETE. The answers were that there is no undelete command and the only real option is restoring from an archive/backup; the only in-engine equivalent is ROLLBACK WORK within an open transaction (not applicable after a committed delete). A poster plugged a commercial file-level undelete product (Recover98), but was challenged to prove it could recover rows inside a database and offered no evidence. No way to recover the committed rows was found.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
SE 5.x Can I recover deleted rows from an Informix Table? The table still exists, and has not been accessed or modified since the errant deletion. IS there a utility available to undelete these?
restore from an archive....no easy way to do what you want....there's no undelete command **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****
At the risk of starting a new thread, I have this question to ask about the lack of an undelete: "If not, why not?" > -----Original Message----- > From: hairbrush@myremarq.com [SMTP:hairbrush@myremarq.com] > Posted At: Tuesday, May 18, 1999 10:51 PM > Posted To: informix > Conversation: Undelete a deleted row > Subject: Re: Undelete a deleted row > > restore from an archive....no easy way to do what you want....there's > no > undelete command > > > > **** Posted from RemarQ - http://www.remarq.com - Discussions Start > Here (tm) ****
In article <245F837E570FD211976200A0C984AF0E2A642A@mailman.mdf.bassinc.com>, "Pachiano, Vince" <pachiano@bassinc.com> wrote: > At the risk of starting a new thread, I have this question to ask about > the lack of an undelete: > > "If not, why not?" > > > -----Original Message----- > > From: hairbrush@myremarq.com [SMTP:hairbrush@myremarq.com] > > Posted At: Tuesday, May 18, 1999 10:51 PM > > Posted To: informix > > Conversation: Undelete a deleted row > > Subject: Re: Undelete a deleted row > > > > restore from an archive....no easy way to do what you want....there's > > no > > undelete command > > > > > > > > **** Posted from RemarQ - http://www.remarq.com - Discussions Start > > Here (tm) **** > > I saw your posting and thought you may be interested in Recover98, a true undelete for Fat32 and NT.Have a look at http://www.phoenixware.com Contact me, Robert Burns at 888-447-1291 ext.163 if you need any assistance. Hope this helps you solve some problems in the future. Sincerely, Robert Burns --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---
Do you actually profess that this package, Recover98, can recover a row deleted from within a database? Tell us how this works, provide some technical proof. Do you have full-function trial software available? (after the technical proof, please). David Russell On Tue, 25 May 1999 18:51:43 GMT, bob_burns_pss@my-dejanews.com wrote: >I saw your posting and thought you may be interested in Recover98, a >true undelete for Fat32 and NT.Have a look at >http://www.phoenixware.com Contact me, Robert Burns at 888-447-1291 >ext.163 if you need any assistance. Hope this helps you solve some >problems in the future. >Sincerely, >Robert Burns
"Pachiano, Vince" <pachiano@bassinc.com> writes: > At the risk of starting a new thread, I have this question to ask about > the lack of an undelete: > "If not, why not?" There is a sort of an undelete, it's called "rollback work". -- Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 President, CEO Fax: (760) 499-9152 My PGP fingerprint: 15 6E C7 91 5F AF 17 C4 24 93 CB 6B EB 38 B5 E5