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: Export w/ rows=N taking hours......

Re: Export w/ rows=N taking hours......

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Sun, 19 Mar 2006 16:17:38 +0300
Message-ID: <97b7fd2f0603190517t4d2560eey63df29cfc6d4e02d@mail.gmail.com>


Just curious to know.
Does this happens even when setting 'statistics' parameter to 'none' in the export?

On 3/17/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Hi Mark,
>
> See Metalink 181072.1 for a couple alternative solutions: 1) remove
> FIRST_ROWS from init.ora or 2) create a logon trigger to set
> optimizer_goal=choose for your exp user.
>
> Regards,
> Brandon
>
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.

--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 19 2006 - 07:17:38 CST

Original text of this message

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