Re: Slow export - OPTIMIZER_GOAL=FIRST_ROWS

> which will activate for this account the trigger :
> CREATE OR REPLACE TRIGGER LOGINTRIGGER AFTER LOGON ON "EXPORTUSER"
> BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET OPTIMIZER_GOAL=CHOOSE';
>
> How do I implement this if the exports are executed from the OEM and
> the jobs are runned by the SYSTEM acount which is set in the Preferred
> Credentials.

replace exportuser by system and recreate the trigger

Stephan Received on Tue Dec 17 2002 - 06:21:28 CST