Re-run of migration workflow throws ORA-00955: name is already used by an existing object
search cancel

Re-run of migration workflow throws ORA-00955: name is already used by an existing object

book

Article ID: 378790

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

When running the Migration workflow, PCK.AUTOMIC_UTF-8-MIG.START, on a restart, the sub-workflow, PCK.AUTOMIC_UTF-8.MIG.STEPS.NOILM.MODE.INITIAL, fails during task PCK.AUTOMIC_UTF-8.MIG-STEP04.CREATE.TABLES.NOILM.DST.  The error in the PLOG (agent report) shows:

create table IDS as select * from  IDS@uc4source where 1=2
ORA-00955: name is already used by an existing object

 

Environment

AE: V12.3 or 21.0 migrating to 24.X

Cause

Tables already exist in the destination database

Resolution

Drop and recreate the destination database and linked db, uc4source

Powered by Wolken Software