Re: Resource to rollback DDL and DML applied in database

You can enable flashback and create guaranteed restore points before the changes are made to the database. Restore to this restore point when you wish to rollback and it is very fast.

Regards
Sreejith

Sent from my iPhone

On 5 Jul 2015 1:12 AM +0530, Ramnivas Chaurasia<ramnivaschaurasia_at_gmail.com>, wrote:
>
> Enabling Flashback might be an option.
>
>
> Ramniwas
>
> On 5 Jul 2015 01:06, "Eriovaldo Andrietta"<ecandrietta_at_gmail.com(mailto:ecandrietta_at_gmail.com)>wrote:
> > Hello guys.
> >
> > I am looking for a way to be able to rollback Changes.
> > This rollback must occur in short time a client offered by the window.
> > Let us imagine that the window is not enough to restore backup base via IMP or via RMANor recover datafile method.
> >
> > The solution I'm looking for is to undo the DDL and DML operations applied on the base.
> >
> > I know that I can develop the rollback for each DDL and DML script.
> >
> > I would like to know if there is a feature in Oracle that does this, fastly.
> >
> > UNDO via recyblebin?????
> >
> > Thanks
> > Eriovaldo
> >
> >
>
>

--
http://www.freelists.org/webpage/oracle-l