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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center