Home » RDBMS Server » Server Administration » Best ways to remove old data and save space?
Best ways to remove old data and save space? [message #50387] Wed, 13 March 2002 12:59 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

I am looking some ways to keep my database small and remove old data from database and archive it somewhere else. the data may need to be put back to the database in the future. One of the things I am conserned is how to enforce constraints? In other words, when I remove data, all the related pk/fk data should be removed together. Any suggestions will be greatly appreciated.

Thanks

Report message to a moderator

Re: Best ways to remove old data and save space? [message #50417 is a reply to message #50387] Thu, 14 March 2002 07:07 Go to previous message
Andrew Lenz
Messages: 16
Registered: August 1999
Junior Member
one idea:

Create a copy of the database on another server.
Write stored procedures to move data to the new database and delete from primary database. You will have to use a combination of stored procedures and cascading constraints to control R.I.

Report message to a moderator

Previous Topic: DBA
Next Topic: Aplication fail in Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 11:57:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.