tag:blogger.com,1999:blog-6716388232100306212.post468912100601444723..comments2023-12-15T22:45:24.138+05:30Comments on Oracle Tips and Techs: Retrieve deleted rows from table using audit.Selvakumar Nagulanhttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-6716388232100306212.post-55922644609871533402014-11-17T17:17:04.975+05:302014-11-17T17:17:04.975+05:30Thanks!Thanks!Selvakumar Nagulanhttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-63082574687190051482014-11-06T06:35:30.295+05:302014-11-06T06:35:30.295+05:30greatgreatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-82277050787843193522012-05-28T20:16:15.920+05:302012-05-28T20:16:15.920+05:30Rajeev, You have to turn on auditing or if you wan...Rajeev, You have to turn on auditing or if you want to check the delete on a particular table you can set up a simple trigger to be initiated whenever data being deleted.Mamu kuttihttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-57139687470133786272012-05-21T19:36:23.024+05:302012-05-21T19:36:23.024+05:30Hi Mamu Kutti,Data is deleting from my table.I wan...Hi Mamu Kutti,<br>Data is deleting from my table.I want to know which procedure is deleting this data.<br>Please send your comments to rajeev.lds@gmail.comRajeevhttp://www.blogger.com/profile/06381291422979868023noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-13377290808965583532012-01-27T18:15:37.221+05:302012-01-27T18:15:37.221+05:30again it is showing "no row selected".again it is showing "no row selected".shiveshdbahttp://www.blogger.com/profile/11262832736719732909noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-39185273392376369082012-01-14T01:44:24.055+05:302012-01-14T01:44:24.055+05:30Check the pfile entry for audit_trail. It should b...Check the pfile entry for audit_trail. It should be set to db. Also if you want to audit sys operations you should set AUDIT_SYS_OPERATIONS = TRUE.Mamu kuttihttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-68528156531387698092012-01-06T20:10:45.822+05:302012-01-06T20:10:45.822+05:30hello sir good morning and happy new year to you.s...hello sir good morning and happy new year to you.sir regarding retrieve deleted rows from table using audit when i fire third command i.e <br><br>SQL> SELECT userid, action#, STATEMENT, OBJ$NAME, To_Char (timestamp#, 'mm/dd/yyyy hh24:mi:ss') FROM sys.aud$ ORDER BY timestamp# asc;<br><br>i get output<br>SQL> no row selected <br><br>but i have already set audit_trail = "db" in v$parameter.<br>please suggest regarding this <br><br>thank you!<br><br>shivesh mishraAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-89560827972235428572011-07-26T21:33:51.616+05:302011-07-26T21:33:51.616+05:30thank you!!thank you!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-56146104788677103272011-07-25T19:45:02.832+05:302011-07-25T19:45:02.832+05:30I have explained step by step by using scott user....I have explained step by step by using scott user. You can try the same as explained!!Mamu kuttihttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-84393581910527260512011-07-23T12:00:07.288+05:302011-07-23T12:00:07.288+05:30thank you sir sir can you elaborate this in steps...thank you sir<br> <br>sir can you elaborate this in steps it will be benifical for me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-73579607334367547562011-07-19T09:36:47.578+05:302011-07-19T09:36:47.578+05:30Once when you truncate a table, the table definiti...Once when you truncate a table, the table definition would be changed i.e. the system time has changed since the last snapshot was taken. So you cannot retrieve the data of a truncated table unless FLASHBACK feature of the database is enabled. <br>You can do a DB point in time recovery to bring back the datas of the table.Mamu kuttihttp://www.blogger.com/profile/03703859252278464644noreply@blogger.comtag:blogger.com,1999:blog-6716388232100306212.post-56680082505108358232011-07-18T20:55:31.618+05:302011-07-18T20:55:31.618+05:30hi sirthank you so so much for giving such a valua...hi sir<br>thank you so so much for giving such a valuable and detailed information regarding this.<br><br>sir one problem is regarding truncate operation .<br>as we know truncate operation in oracle sever delete the rows permanently of specified table.<br>if i do this truncate operation in same scenario as we earlier discussed. is there any chance to retrieve it back in reality.<br><br>if you will suggest regarding this the i will greateful to youAnonymousnoreply@blogger.com