When running PL/SQL block in RSA Identity Governance and Lifecycle, the following error occurs: ORA-01471: cannot create a synonym with same name as object
Originally Published: 2016-10-27
Article Number
Applies To
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0 and 7.0.1
Platform: WebSphere
Platform (Other): AIX
Issue
SQL> begin
2 FOR rec IN (select 'create or replace synonym ' || TO_CHAR(view_name) || ' for avuser.' || TO_CHAR(view_name) cmd
3 from avuser.T_AV_REPORTS
4 where regexp_like(view_name,'^[vV]_[a-zA-Z0-9_]+$')
5 and LENGTH(view_name) <= 30 AND REPORT_CATEGORY = 'Migration')
6 loop
7 execute immediate rec.cmd;
8 end loop;
9 end;
10 /
begin
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object
ORA-06512: at line 7Cause
Resolution
A documentation ticket has been logged (ACM-69154) to update the RSA Identity Governance and Lifecycle V7.0.1 Upgrade and Migration Guide to reflect this necessary step.
Related Articles
ASR fails to generate with an 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' error in RSA … Number of Views ASR Report fails with ERROR ORA-06502: PL/SQL: numeric or value error: character string buffer too small in RSA Identity G… Number of Views RSA Identity Governance and Lifecycle Identity Data Unification fails with ORA-06502: PL/SQL: numeric or value error: Bulk… Number of Views After applying a patch, an 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' error occurs whe… Number of Views RSA Via L&G Supported OS Required Packages Number of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 Downloading RSA Authentication Manager license files or RSA Software token seed records AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and mule_e… RSA Authentication Manager 8.7 SP1 Patch 1 Hotfix 1 RSA Authentication Manager 8.8 Security Configuration Guide
Don't see what you're looking for?
