Home » RDBMS Server » Backup & Recovery » Undo db changes of particular user in particular date (oracle 9i forms, 9i DB)
Undo db changes of particular user in particular date [message #326565] Thu, 12 June 2008 00:17 Go to next message
lokimisc
Messages: 88
Registered: February 2008
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
Re: Undo db changes of particular user in particular date [message #326580 is a reply to message #326565] Thu, 12 June 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Undo db changes of particular user in particular date [message #326705 is a reply to message #326565] Thu, 12 June 2008 05:57 Go to previous messageGo to next message
lokimisc
Messages: 88
Registered: February 2008
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
Re: Undo db changes of particular user in particular date [message #326711 is a reply to message #326705] Thu, 12 June 2008 06:29 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Fri Dec 09 03:59:22 CST 2016

Total time taken to generate the page: 0.07622 seconds