Re: Is it possible to archive data to tape ??

Yes, you can. You can use the export utility to extract to disk or tape. You can also extract/import by partition (see below).

As regards processing large tables (i.e. adding a new months worth of data and trimming off an old month from say 2 years back) I'd strongly recommend Oracle 8 with the Partitioning Option. Partitioned tables - if implemented correctly - are very effecient from both the performance and maintenance aspects. Our monthly archive (on 100,000,000 row tables) came down from hours to minutes when we moved to Oracle 8 partitioning.

MotoX.

slryf_at_cc.usu.edu wrote in message ...
>
>I had a question regarding archiving data in Oracle. Not
>to be confused with "Archive Log" archiving.
>Instead if certain tables in the database grow rapidly
>and old data needs to be archived (to tape, for e.g.).
>Can it be done in such a way as to retrieve the data quickly
>and can it be done in such a way that data can be continuously
>archived so that the primary tables do not grow out of control
>and hence run out of disk space.
>Am i way of the mark here or is there something available to
>be able to do this.
>Thanks a bunch for any clues on this.
>Raghu
Received on Wed Jul 08 1998 - 03:03:16 CDT