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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: historical data

RE: historical data

From: Oriole <info_at_oriole.com>
Date: Sat, 26 May 2001 14:18:16 -0700
Message-ID: <F001.003109E5.20010526141021@fatcity.com>

Chris Spence was kind enough to mention PDQout in his response to this question and the debate since then seems to have revolved around whether exp/imp will still be around to reload archive data. There can be no debate with PDQout however. It creates flat files which can be reloaded with sqlldr (compare the speed of that with the speed of imp), or any other bulk loader. So you can be sure that you can reload into Oracle or into any other database, at any time in the future. Additionally, as PDQout makes use of the Oracle Call Interface, it can work across SQL*Net or download a view, saving a lot of processing when preparing data for a datamart. Sorry for the plug but what would you have done :-) Anyway to assuage your anger, you can get a FREE version of PDQout from our website, which will allow the downloading of tables of up to 250k rows.
Oh! Just one thing, that version can't download views, we're not that stupid :-)

Regards,
Oriole Corporation,
Oracle Performance Tools and Free Scripts Email: info_at_oriole.com
Tel: +44 (0)20 7872 5480
Faxes: UK +44 (0)705 066 8661 US +1 240 526 5946 http://www.oriole.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Oriole
  INET: info_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat May 26 2001 - 16:18:16 CDT

Original text of this message

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