Adadmin: Error While Recreate grants and synonyms for APPS schema(s) in ADADMIN
Hi, I get the next error when Recreate grants and synonyms for APPS schema(s) with Adadmin:
sqlplus -s APPS/***** @/u01/laboappl/ad/11.5.0/admin/sql/adappsgs.pls &systempwd 1 XX APPLSYS APPS TRUE FALSE TRUE
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,'XX','APPLSYS','APPS','FALSE');
begin
*
ERROR at line 1:
ORA-20000: ORA-00955: name is already used by an existing
object:create_grants_and_synonyms(1,XX,APPLSYS,APPS): create_base_gs(XX,APPS):
In Synonyms Loop:create_synonym(XX,XX_AP_INVOICE_INT,APPS,XX_AP_INVOICE_INT):
sqlplus -s APPS/***** @/u01/laboappl/ad/11.5.0/admin/sql/adappsgs.pls &systempwd 1 XX APPLSYS APPS TRUE FALSE TRUE
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,'XX','APPLSYS','APPS','FALSE');
begin
*
ERROR at line 1:
ORA-20000: ORA-00955: name is already used by an existing
object:create_grants_and_synonyms(1,XX,APPLSYS,APPS): create_base_gs(XX,APPS):
In Synonyms Loop:create_synonym(XX,XX_AP_INVOICE_INT,APPS,XX_AP_INVOICE_INT):
Tagged:
0