Re: How to detach/archive data

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 25 Jul 2002 00:06:29 +0200
Message-ID: <ne8ujucdhdr4dlbicboqo40scscslctehh@4ax.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote:

>Another option you could consider is to simply export the table(s) using the
>QUERY option and export only those rows of (no longer) interest (and import
>when required).

But will exported rows still remain in the DB in this case?

>How you would automatic with a robotic tape system through an application I
>know not. I'll leave the easy bit to someone else :)

That is the simplest part. Oracle does not need to know anything about that, it uses files that are "there" in some path. The HSM system manages the rest automatically.

Thanks
Rick Received on Wed Jul 24 2002 - 17:06:29 CDT