Error: The specified name already exists/Business table already exists

Error Message

When creating a new feature class in ArcSDE for Oracle, the following error message is received:

"The specified name already exists. Please enter a different name".

When importing an export file using the 'sdeimport -o create' command, the following error message is received:

"Business table "<name>" already exists".

After checking the repository tables, the feature class name does not exist, so this should be working.


One possible cause for these errors is that a PUBLIC SYNONYM exists with the same name specified for the feature class being created.

Solution or Workaround

Follow the steps below to drop the PUBLIC SYNONYM:

  1. Connect to SQL*PLUS as the SYS user.
  2. Execute the following queries:

    SQL> drop PUBLIC SYNONYM <name>;

    SQL> commit;

    After these queries are executed, creating a feature class or importing the export file with the desired name, executes successfully.