After changing one of the table definitions, the following error occurs on target:
Error 2015-02-01 22:04:34.695847 26496 3967600960 s:2 Poster: Unexpected Oracle error: ORA-00957: duplicate column name. (object name: "TIAACREF_REPORTING"."U_LDAP_EMP_CW_USER_LOAD") (posting from db162088, queue ora162088, to db24850) [module opo]
DDL sequence
1. alter table add column NEW_COLUMN
2. update PROBLEM_TABLE set NEW_COLUMN = WILL_BE_DROPPED_COLUMN;
3. commit;
4. alter table drop column WILL_BE_DROPPED_COLUMN
5. alter table rename NEW_COLUMN to DROPPED_COLUMN_NAME
Target failed to update object cache with the latest information.
8 4000 VARCHAR2 u_memberof Nullable
Destination column name: u_memberof
23 0 CLOB u_memberof Nullable
Destination column name: u_memberof
24 0 CLOB u_memberof_temp Nullable
Destination column name: u_memberof_temp
Column #8 has the same name as column #23, and temp column was not dropped from it.
manually update object cache.
From source:
1. sp_ctrl>stop capture
2. sp_ctrl>show
>> to make sure capture stop
3. sp_ctrl>start capture
4. cd $SP_SYS_VARDIR/state
copy the latest ocap objcache to target
From target
1. sp_ctrl>stop post queue <queue_name> (if it is still running)
2. cd $SP_SYS_VARDIR/state
3. backup the current object cache for that queue
4. replace the current object cache for that queue with the copied of capture object cache
5. sp_ctrl>start post
