RE: RE: Re: Is sqlplus too slow to unload data?]

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 30 Apr 2002 06:43:29 -0800
Message-ID: <F001.00453492.20020430064329@fatcity.com>

('binary' encoding is not supported, stored as-is)

>Stephane,
>
>pdqout does give me a real good impression, not
>only the speed but also the
>interface. I can see it uses parallel query.
>However, I, as a production
>DBA, intend to change the application which come
>from a third party as a
>package as small as possible. It takes 4hours to
>extract data at 5M/minute.
>If the speed of sqlplus can be increased to
>20M/minute, I achieve the goal.
>
>Just one thing about pdqout confuses me. I have to
>use DBA account,
>otherwise I get the following error.
>'> Oracle oexfet() failure (-907)
>> ORA-00907: missing right parenthesis '
>
>Kind Regards,
>Bin

AFAIK it's a bug who has stayed in some versions, due to an innate tendency to make a distinction between the DBA elite and the scum of the earth ;-).

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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 Tue Apr 30 2002 - 09:43:29 CDT