EXECUTE DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE ( -
OWNER => 'SALES_OP', -
CHANGE_TABLE_NAME => 'CDC_PRICE_LIST', -
CHANGE_SET_NAME => 'SYNC_SET', -
SOURCE_SCHEMA => 'SALES_OP', -
SOURCE_TABLE => 'PRICE_LIST', -
COLUMN_TYPE_LIST => 'PRODUCT_ID	VARCHAR2(20), -
  		  UOM		VARCHAR2(20), -
  		  PRICE_PER_UOM	NUMBER(10,2)',  -
CAPTURE_VALUES => 'BOTH', -
RS_ID => 'N', -
ROW_ID => 'N', -
USER_ID => 'Y', -
TIMESTAMP => 'Y',  -
OBJECT_ID => 'N', -
SOURCE_COLMAP => 'N', -
TARGET_COLMAP => 'N', -
OPTIONS_STRING => NULL);


EXECUTE DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE ( -
OWNER => 'SALES_OP', -
CHANGE_TABLE_NAME => 'CDC_SALES_TRAN', -
CHANGE_SET_NAME => 'SYNC_SET', -
SOURCE_SCHEMA => 'SALES_OP', -
SOURCE_TABLE => 'SALES_TRAN', -
COLUMN_TYPE_LIST => 'PRODUCT_ID	VARCHAR2(20), -
                   SALE_DATE_TIME	TIMESTAMP(6), -
  		  QUANTITY		NUMBER(10,2)',  -
CAPTURE_VALUES => 'BOTH', -
RS_ID => 'N', -
ROW_ID => 'N', -
USER_ID => 'Y', -
TIMESTAMP => 'Y',  -
OBJECT_ID => 'N', -
SOURCE_COLMAP => 'N', -
TARGET_COLMAP => 'N', -
      OPTIONS_STRING => NULL);