Topic:   Issue faced while migrating TN tables from 8.2 to 9.6
Jul 01, 2014 21:29 3 Replies 701 Views MITHILESH
Prev Next
Topic Replies (3)
  1. 1
    idnkx user

    MITHILESH

    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

    1
    idnkx user

    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]

    1
    idnkx user

    Ansari

    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

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect