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: <9l8ujukefhsi8ik41v0omdom8me6kj18lu@4ax.com>

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:

>Rick,
>
>don't quote me on this, but in Oracle 9i you have EXTERNAL tables which
>can be queried through standard SQL (with a few limitations). If your
>tape robot is able to load the correct tape on demand, this MIGHT be a
>way forward.
>

OK, we will have to upgrade to 9i then. This external feature sounds quite interesting.

And yes, the tape robot will load the correct tape on demand. The mechanism to do it is completely transparent to Oracle, since inodes are present on disk, only the files themselves aren't.

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