My Oracle Support Banner

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 later
Information 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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.