Hi Buddies,
I am using 'chang data capture' in 9i db.
I copy and past and custermize DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE like below.
EXECUTE DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE (OWNER => 'cdc',\
CHANGE_TABLE_NAME => 'CLAIM_ct', \
CHANGE_SET_NAME => 'SYNC_SET', \
SOURCE_SCHEMA => 'RDRDBA', \
SOURCE_TABLE => 'CLAIM',\
COLUMN_TYPE_LIST =>. 'CLM_ID number(22), CLM_IDNTFCTN_CD varchar2(15), INJRY_TYPE_CD varchar2(2), CLM_STTS_CD varchar2(2)', \
CAPTURE_VALUES => 'both', \
RS_ID => 'y' \
ROW_ID => 'n', \
USER_ID => 'n', \
TIMESTAMP => 'n', \
OBJECT_ID => 'n', \
SOURCE_COLMAP => 'y', \
TARGET_COLMAP => 'y', \
OPTIONS_STRING => null);
..To my surprise, I got a bunch of errors, ... like
BEGIN DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE (OWNER => 'cdc',\; END;
*
ERROR at line 1:
ORA-06550: line 1, column 67:
PLS-00103: Encountered the symbol "\" when expecting one of the following:
( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
SP2-0024: Nothing to change.
SP2-0024: Nothing to change.
SP2-0734: unknown command beginning "SOURCE_SCH..." - rest of line ignored.
SP2-0734: unknown command beginning "SOURCE_TAB..." - rest of line ignored.
SP2-0158: unknown COLUMN option "=>."
SP2-0734: unknown command beginning "CAPTURE_VA..." - rest of line ignored.
SP2-0734: unknown command beginning "RS_ID => '..." - rest of line ignored.
SP2-0734: unknown command beginning "ROW_ID => ..." - rest of line ignored.
SP2-0734: unknown command beginning "USER_ID =>..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "TIMESTAMP ..." - rest of line ignored.
SP2-0734: unknown command beginning "OBJECT_ID ..." - rest of line ignored.
SP2-0734: unknown command beginning "SOURCE_COL..." - rest of line ignored.
SP2-0734: unknown command beginning "TARGET_COL..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "OPTIONS_ST..." - rest of line ignored.
what is wrong?
Thanks a lot in advance
Jerry