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@xxxxxxxxxxx> 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." -- //www.freelists.org/webpage/oracle-l