Error: The specified name already exists/Business table already exists
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:
- Connect to SQL*PLUS as the SYS user.
- Execute the following queries:
SQL> drop PUBLIC SYNONYM <name>;
After these queries are executed, creating a feature class or importing the export file with the desired name, executes successfully.