OraFAQ Forum: Backup & Recovery » Undo db changes of particular user in particular date

Home » RDBMS Server » Backup & Recovery » Undo db changes of particular user in particular date (oracle 9i forms, 9i DB)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Undo db changes of particular user in particular date [message #326565]

Thu, 12 June 2008 00:17

lokimisc
Messages: 101
Registered: February 2008

Senior Member

Hi All,
I have one query.

Is it possible to undo all the DML operations done by a particular user (using oracle forms 9i) on a particular date in particular environment say testing or development.

Thanking You

regards,
lokesh

Report message to a moderator

Re: Undo db changes of particular user in particular date [message #326580 is a reply to message #326565]

Thu, 12 June 2008 01:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Rollback?

Outside the transaction itself there is no direct way, you have to use Log Miner to find has been done and undo it.

Regards
Michel

Report message to a moderator

Re: Undo db changes of particular user in particular date [message #326705 is a reply to message #326565]

Thu, 12 June 2008 05:57

lokimisc
Messages: 101
Registered: February 2008

Senior Member

Thanks for your answer.

Basically Iam a developer. So can you please explain how to use log miner to undo database changes done by a particular user in particular date in particular environment ( like testing, development ).

( oracle forms 9i is used as a front tool )

Thanking You

regards,
lokesh

Report message to a moderator

Re: Undo db changes of particular user in particular date [message #326711 is a reply to message #326705]

Thu, 12 June 2008 06:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you are a developer you can't use Log Miner which requires some admin privileges.
In addition, it is NOT a normal way, it is for recovery, audit or so purposes.
In application, you have to use correct transaction behaviour. The way to undo work is to use "rollback".

Regards
Michel

[Updated on: Thu, 12 June 2008 06:30]

Report message to a moderator

Previous Topic:	selective data transfer from old to new database
Next Topic:	RMAN output logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 20:32:07 CST 2024