hi,
Iam getting the below error when iam trying to migrate the TN archieve tables from 8.2 to 9.6. Please let me know how can these be resolved if any one of you have faced this error ealier :

IGRATE TRADINGNETWORKSARCHIVE [45.0] FAILED
CDC ERROR [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

Suspending execution...

------------------------------------------------------------
Summary of installation errors
------------------------------------------------------------
Error in executing file /u01/app/webMethods96/WM96POC/common/db/scripts/oracle/tradingnetworksarchive/migrate/37_to_38/ora_tna_m_37_to_38.sql
SQL error [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object



thanks
Mithilesh

[quote="mith3110" post=1004]hi,
Iam getting the below error when iam trying to migrate the TN archieve tables from 8.2 to 9.6. Please let me know how can these be resolved if any one of you have faced this error ealier :

MIGRATE TRADINGNETWORKSARCHIVE [45.0] FAILED
CDC ERROR [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

Suspending execution...

------------------------------------------------------------
Summary of installation errors
------------------------------------------------------------
Error in executing file /u01/app/webMethods96/WM96POC/common/db/scripts/oracle/tradingnetworksarchive/migrate/37_to_38/ora_tna_m_37_to_38.sql
SQL error [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object



thanks
Mithilesh[/quote]

Mith,

[b]ORA-00955[/b] name is already used by an existing object shows an attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user's database objects must have distinct names.

You should enter a unique name for the database object or modify or drop the existing object so it can be reused. If there is an attempt to create an existing database object, ORA-00955 error will be thrown and this includes objects such as table, view, cluster, index, or synonym

To resolve ORA-00955, make sure to give the database object an unmatched name. You can also drop or modify the existing object so that it can be reused, without being identical syntax.

Hope this helps