After moving/copying an instance can't copy/create some new objects.

Document ID : KB000090456
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
After moving/copying an instance can't copy/create some new objects.
Resolution:
Detailed Description and Symptoms

?After copy/moving an instance when you try and create new objects or copy ones all ready in the system you receive an error message similar to:

java.sql.SQLException: ORA-00001: unique constraint (UC4.SO_JOB_TABLE_IDX) violated
 
You may be able to create some objects(logins) while being unable to create others(queues).

 

Solution

?This issue occurs when you import data from a previous schema over another without dropping objects ahead of time. This ends up replicating sequence numbers.

to resolve please drop objects on the instance you are trying to import in as per or manuals and then re-run the import:

To drop the table you nee to run the following sql from the manuals:

Step 2: Drop the Oracle user objects

To prepare the target Applications Manager database to receive data from the source database, you must remove all objects from the database, but leave the Oracle user and system grants in place. Before issuing the commands to drop the objects, issue the following:

SQL> show user

If this returns SYS or SYSTEM, DO NOT run the drop script, and instead log in as the Applications Manager Oracle user. Please contact Automic Support for statements to remove these objects.