Addropschema.sql Script Error- ORA-01031: insufficient privileges
(Doc ID 2975293.1)
Last updated on SEPTEMBER 25, 2023
Applies to:
Oracle Applications DBA - Version 12.2.10 to 12.2.2 [Release 12.2 to 12.2Cloud]Information in this document applies to any platform.
Symptoms
On : 12.2.10 version, Upgrade related issues
Addropschema.sql Script Error
While running addropschema.sql script to remove Obsolete Objects, getting the following error:
ERROR
-----------------------
SQL> @$AD_TOP/patch/115/sql/addropschema.sql_BKP APPLSYS OKR
Connected.
declare
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 14
ORA-06512: at line 11
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Running addropschema.sql script
BUSINESS IMPACT
-----------------------
Due to this issue, users cannot run the addropschema.sql script to remove the obsolete objects / schemas.
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 |
References |