RE: export with "first rows"

There were posts re. first_rows last week I think - stick to CHOOSE, problems occur if you use first_rows and all_rows in init.ora. Something to do with how the Oracle database engine accesses internal objects.

Which vendor would require that you use first_rows for the whole database?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

 -----Original Message-----

Sent:	Thursday, August 15, 2002 10:23 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: export with "first rows"

The export views created by the catexp script are totally screwed if you have FIRST_ROWS as your optimizer setting.
Either use CHOOSE or edit the views to include a RULE hint on all SELECT statements
and you'll be fine.

And if you tell Oracle support I recommended you did this, I'll personally come around and snip your doolies off.

Cheers
Nuno Souto
nsouto_at_optushome.com.au

> Ed Lewis <eglewis_at_hotmail.com> wrote:
>
> Hello,
> We have the optimizer mode set to "first rows"
> on our (25gb) database to meet a vendor requirement.
> When I do an "direct" export, it runs for 6-7 hours.
>
> When I change the optimizer mode to "choose" it
> runs in around an hour.
> It also runs in an hour when I set the the optimizer
> mode to "first rows", and run stats on the "sys" schema.
>
> I'm curious why this occurs. Has anyone experienced
> this ? Any ideas why this happens ? Is this normal behavior ?
> I could not find anything on metalink. thanks.
>
> Oracle 8.1.7.2, aix 4.3.3.
>

> ed

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nuno Pinto do Souto
  INET: nsouto_at_optushome.com.au

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).