oracle Golden Gate extract problem
From
solaris_11@21:1/5 to
All on Wed Apr 20 16:48:38 2016
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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)