oracle Golden Gate extract problem
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