Has anyone come across this situation - unable to create synonym because of an existing object with
I have upgraded the 11.2.0.3 database to 12.1.0.2 for EBS. My attempt to re-create synonyms in APPS schema as part of the upgrade failed.
adadmin
Choose -> Maintain Applications Database Entities menu
Choose -> Re-create grants and synonyms for APPS schema
sqlplus -s APPS/***** @/app/oracle/xxx/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adappsgs.pls &systempwd 1 FV APPLSYS APPS TRUE FALSE TRUE
Connected.
Connected.
old 2: ad_apps_private.create_grants_and_synonyms(&2,'&3','&4','&5','FALSE');
new 2: ad_apps_private.create_grants_and_synonyms(1,'FV','APPLSYS','APPS','FALSE');
begin
*
ERROR at line 1:
ORA-20000: ORA-00955: name is already used by an existing
Tagged:
0