Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to detach/archive data

Re: How to detach/archive data

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 25 Jul 2002 00:34:57 +0100
Message-ID: <3d3f6a67_2@mk-nntp-1.news.uk.worldonline.com>


"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702696EA2_at_lnewton.leeds.lfs.co.uk...
> 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.
>
> I'm not using 9I yet, so I can't say for certain.
>
>

Don't get too excited yet about this promising new feature. As of now it's only a SQL*Loader definition of a flat file, stored in the data dictionary.

Paul Received on Wed Jul 24 2002 - 18:34:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US