Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    CREATE SYNONYM error: name is already used by an existing object

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    When we do Step 9, Option 1, in the "Parallel Indexing" document to create the Logical Synonyms, we get the following error for the z980, z970, and z101:

    CREATE SYNONYM ...
    ERROR at line 1:
    ORA-00955: name is already used by an existing object

    Resolution:
    This error occurs when the tables (in this case, the z980, z970, and z101) were not dropped prior to doing the util a/17/5.

    You need to drop the tables (in the actual library) and then re-run util a/17/5 (in the actual library).

    Additional Information

    faq


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged