Re: how do I undo record deletions?

Can Logminer be used to undo table drops or table truncates?

> Another solution: You can use logminer (see Oracle documentation) to
 analyze
> your redo-logs. It gives you for every statement executed (delete..)
 also
> the appropriate undo-statement (insert...). If your database has low
 update
> activity it could be the faster solution.
>
> Klaus
> ekrem <nospam_at_dot.com> schrieb in im Newsbeitrag:
> rLub5.11315$c5.31718_at_newsfeeds.bigpond.com...
> > hi,
> >
> > either someone within my workplace has untentionally deleted all
 records
> > from one of the tables or they've been deleted by some other unknown
 event,
> > because the table in question is currently empty.
> >
> > this happened about 2-3 days ago. is there a way for me to undo the
 deletes
> > or recover the table contents somehow?
> >
> > the archive log files go back about 2 weeks and it's running on
 oracle
 8.15
> > on solaris 7.
> >
> > thanks
> > ekrem
> >
> >
> >
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 16 2000 - 00:00:00 CDT