Problem solve Get help with specific problems with your technologies, process and projects.

Dealing with old and infrequently used data

What is the best practice to deal with data that is old and infrequently used?

There is no "best" practice because this is largely determined by your company's policies relating to older data. Can the old data be simply deleted? Must it be archived for a certain number of years? If it is archived, will it be used on a semi-regular basis or almost never? Once you start to answer these questions, you can determine which method is best for you.

To give you an idea of the different methods, we'll go through a few scenarios.

If the data can simply be deleted, the DELETE statements against appropriate tables can help.

If the data needs to be accessed frequently, many people move the old data to an archive table. Then production can access the new data, while keeping the older data in the database. Many people also set up a data warehouse (if that is appropriate) for their older information. Also, many people don't need all of the details of their older data so they aggregate it.

If the data needs to be accessed only in rare circumstances, then it is probably best to keep the data out of the database. Export the data. Unplug a tablespace. Or whatever works to remove the data from the database, but keep it in a format that can easily be added to the database.

For More Information

This was last published in March 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.