Answer Posted / qasim
Data purging is just deleting the old data from the tables
in the database.
In my opinion data purging is not needed in transaction
tables/records such as sales, purchase etc.
Suppose you have a database application, which records
security information like logins, logouts, modifications on
the data or audit trails/history of modifications , then
it is obvious that this information will require additional
space. Since this information will help security
administrators for investigation purpose only you can take
a backup of this information and can delete.
Furthermore its up to your requirement, that at a given
point of time you want to retain data for last (N no of
months) then you can keep, otherwise delete all.
| Is This Answer Correct ? | 36 Yes | 7 No |
Post New Answer View All Answers
what are different storage options supported by oracle ?
What is index awareness in universe?
In document how to create metrics?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
what type of raid setup would you put your tx logs?
What is the limit to the number of sources and targets you can have in a mapping?
Describe the differences between a data warehouse and data mart.
How to create prompts in report net?
What is execution plan?
What is cost benefit analysis (cba)?
What is defined as partial backup?
Where the cache files stored?
Explain what is the metadata extension?
how much memory space occupied real time project (roughly)?
What is the advantages data mining over traditional approaches?