DBSFWUSER.DBMS_SFW_ACL_ADMIN Package Body Invalid due to ORA-00942: table or view does not exist
(Doc ID 2739628.1)
Last updated on DECEMBER 28, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 19.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Running datapatch -verbose after applying Oct security database patches 29319558, 31771877
Patch 31771877 apply: WITH ERRORS
logfile: /app01/oracle/cfgtoollogs/sqlpatch/31771877/23869227/31771877_apply_OEM13CR4_2020Dec18_18_19_39.log (errors)
-> Error at line 7642: script rdbms/admin/prvtaclsrv.plb
- ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
- of an existing object.
sql> @?/rdbms/admin/prvtaclsrv.plb
PL/SQL procedure successfully completed.
Warning: Package Body created with compilation errors.
Session altered.
SQL> show errors;
Errors for PACKAGE BODY DBSFWUSER.DBMS_SFW_ACL_ADMIN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
104/5 PL/SQL: SQL Statement ignored
105/34 PL/SQL: ORA-00942: table or view does not exist
268/7 PL/SQL: SQL Statement ignored
268/19 PL/SQL: ORA-00942: table or view does not exist
276/5 PL/SQL: SQL Statement ignored
276/17 PL/SQL: ORA-00942: table or view does not exist
284/3 PL/SQL: SQL Statement ignored
284/57 PL/SQL: ORA-00942: table or view does not exist
308/7 PL/SQL: SQL Statement ignored
PL/SQL procedure successfully completed.
Warning: Package Body created with compilation errors.
Session altered.
SQL> show errors;
Errors for PACKAGE BODY DBSFWUSER.DBMS_SFW_ACL_ADMIN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
104/5 PL/SQL: SQL Statement ignored
105/34 PL/SQL: ORA-00942: table or view does not exist
268/7 PL/SQL: SQL Statement ignored
268/19 PL/SQL: ORA-00942: table or view does not exist
276/5 PL/SQL: SQL Statement ignored
276/17 PL/SQL: ORA-00942: table or view does not exist
284/3 PL/SQL: SQL Statement ignored
284/57 PL/SQL: ORA-00942: table or view does not exist
308/7 PL/SQL: SQL Statement ignored
Changes
Running datapatch -verbose after applying Oct security database patches 29319558, 31771877
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 |