oracle Golden Gate extract problem

From: solaris_11 <solaris_at_wp.pl>
Date: Wed, 20 Apr 2016 16:48:38 +0200
Message-ID: <571796c3$0$701$65785112_at_news.neostrada.pl>



Hello !

Just quick question for the bravest OGG specialist.

Is you see, what extract (inital load when sqlpredicate is used) is doing, you notice: (example)

SQL <SELECT
x."RI_ZAD_OID",x."RI_ZAD_OTYPE",x."NR_SAP",x."OPIS",x."LAST_MOD_DT",x."LAST_MOD_BY" FROM "PI_WYK"."CSN_DETAIL" x >.

Question: how to get rid of that alias "x", so OGG would generate SLQs without that "X" ?

if you define in extract

MAP PI_WYK.CSN_DETAIL sqlpredicate "PARTITION (SYS_P99)";

will not work because

OCI Error ORA-00924: missing BY keyword (status = 924), SQL <SELECT x."RI_ZAD_OID",x."RI_ZAD_OTYPE",x."NR_SAP",x."OPIS",x."LAST_MOD_DT",x."LAST_MOD_BY" FROM "PI_WYK"."CSN_DETAIL" x PARTITION(SYS_P99) >.

this does not work:
...FROM "PI_WYK"."CSN_DETAIL" x PARTITION(SYS_P99) >.

this works

...FROM "PI_WYK"."CSN_DETAIL" PARTITION(SYS_P99) x>.

Best regards
Marek Received on Wed Apr 20 2016 - 16:48:38 CEST

Original text of this message