OraFAQ Forum: Server Administration » Best ways to remove old data and save space?

Home » RDBMS Server » Server Administration » Best ways to remove old data and save space?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Best ways to remove old data and save space? [message #50387]

Wed, 13 March 2002 12:59

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 19:27:15 CDT 2025