How to detach/archive data

Hello

We have limited space for live DB files, which contain a considerable amount of seldom used data. At the same time, we have a tape robot which could save virtually any amount of data.

What is the method to detach portions of the data to be archived in a way that one could consistently attach them again when needed? Perhaps using partitions?

Preferably, I would not delete records since this renders the DB in a devastated state and one would have to reorganize data. Using export/import is not a solution either since it applies to complete objects. And I would avoid a method that would imply complex reloads and index recreation etc. when restoring archived data.

Since our tape robot is under HSM control (hierarchical file system), would it be feasable to automate the process of reattaching detached data when required by an Oracle application? That is, without any human intervention, Oracle would look for the archived file, which would then be staged to disk from tape by the HSM, and Oracle would resume operations after reintegrating the file into the DB. But I suspect a timeout problem there, since tape robots are relatively slow from the Oracle viewpoint.

Please give me some hints so I can move in the right direction.

Thanks
Rick Received on Tue Jul 23 2002 - 17:21:33 CDT