f



oracle Golden Gate extract problem

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 


0
solaris_11
4/20/2016 2:48:38 PM
comp.databases.oracle.misc 8436 articles. 1 followers. Post Follow

0 Replies
218 Views

Similar Articles

[PageSpeed] 47

Reply: