My Oracle Support Banner

Error Trying To Create Synonym CS_LOOKUPS For CS.CS_LOOKUPS (Doc ID 458600.1)

Last updated on AUGUST 14, 2023

Applies to:

Oracle Teleservice - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2:
When attempting to recreate grant and synonym in apps schema via adadmin,
the following error occurs when adadmin is executing adappsgs.pls:

ERROR at line 1:
ORA-20000: ORA-00955: name is already used by an existing object:
create_grants_and_synonyms(1,CS,APPLSYS,APPS): create_base_gs(CS,APPS):
In Synonyms Loop:create_synonym(CS,CS_LOOKUPS,APPS,CS_LOOKUPS):
do_apps_ddl(APPS,CREATE SYNONYM "CS_LOOKUPS" FOR CS."CS_LOOKUPS"):
ORA-06512: at line 5

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.