Designer data export and obsolete OPTIMIZER_GOAL parameter
From: Tomasz Wrzodak <tomaszw**nospam**_at_meritus.pl>
Date: Sun, 19 Jun 2005 23:27:43 +0200
Message-ID: <d94nv7$7nf$1_at_achot.icm.edu.pl>
Hi,
I have a problem with data export from Designer Repository (Rep. Object Navigator). Error message indicates that Designer (before running exp utility) tries to set OPTIMIZER_GOAL parameter (alter session) which is obsolete.
I tried it on two databases: first one upgraded from 8.1.7 to 10.1.0.2 (with installed Oracle Repository 4.0.12.94.24), second created on 10g server with new Oracle Repository (also 4.0.12.94.24 version). So I think problem is in Designer (database parameter OPTIMIZER_MODE was set to ALL_ROWS).
I use Designer v.9.0.4.3.14 from Developer Suite 10g. Help please! Received on Sun Jun 19 2005 - 23:27:43 CEST
Date: Sun, 19 Jun 2005 23:27:43 +0200
Message-ID: <d94nv7$7nf$1_at_achot.icm.edu.pl>
Hi,
I have a problem with data export from Designer Repository (Rep. Object Navigator). Error message indicates that Designer (before running exp utility) tries to set OPTIMIZER_GOAL parameter (alter session) which is obsolete.
I tried it on two databases: first one upgraded from 8.1.7 to 10.1.0.2 (with installed Oracle Repository 4.0.12.94.24), second created on 10g server with new Oracle Repository (also 4.0.12.94.24 version). So I think problem is in Designer (database parameter OPTIMIZER_MODE was set to ALL_ROWS).
I use Designer v.9.0.4.3.14 from Developer Suite 10g. Help please! Received on Sun Jun 19 2005 - 23:27:43 CEST