• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Save deleted records

Hello experts,

my boss requested that before my application delete a record , it should be saved the record in a txt file before the actual delete happened so the user can retreive his/her information if they delete it by mistake.

do you have a good idea to implement this ? from java side or from oracle database side ?
and whay shall i exactly save in the txt file ?

Thank you :)
0
Web_Admin
Asked:
Web_Admin
  • 3
  • 2
  • 2
  • +1
1 Solution
 
for_yanCommented:
Seems to be starightforward in java - just write to a file before deleting the record.
In Oracle you can set up automatic capturing of deleted records in the special table
which will keep traclk of original table updates and also keep a copy of
deleted records.
0
 
myaspnetCommented:
you must save record on temp table
like this
http://www.myaspnet.com/codedisplay.aspx?id=662
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
for_yanCommented:


If you are using Oracle 11 you can use flshback archive
http://www.oracle-base.com/articles/11g/FlashbackAndLogminerEnhancements_11gR1.php

If you are on earlier versions of Oracle you can create trigger which will
store the record before deleting it to another table
0
 
Web_AdminAuthor Commented:
I know how to implement it in java , but i would like to know what is the best way to achieve this
? to save the records in db or in file system ><
0
 
objectsCommented:
easiest to do it in the database, either to a another table of an export.
0
 
for_yanCommented:
If they potentially will be accessing these copies often and soon after the deleting then files are pribably better, if you think these copued data may stillbe  important in years then db seems a better choice
0
 
Web_AdminAuthor Commented:
@for_yan: Thank you

Thank you all :)
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now