INVALID Objects after applying patch using datapatch -verbose -apply 27849051 –force on windows (Doc ID 2432940.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Invalid objects are found on the database after applying a patch

select owner, object_type, status from dba_objects where
status = 'INVALID' order by 1,2,3;

SQL> select owner, object_type, status from dba_objects where status = 'INVALID' order by 1

OBJECT_NAME OWNER OBJECT_TYPE STATUS
------------------------------ --------------- ----------------------- -------
SDO_META SYS PACKAGE INVALID
MDPRVT_GMD SYS PACKAGE INVALID
MDPRVT_GMD SYS PACKAGE BODY INVALID
SDO_META SYS PACKAGE BODY INVALID
SDO_INDEX_METHOD_10I SYS TYPE INVALID
MDPRVT_IDX SYS PACKAGE INVALID
PRVT_IDX SYS PACKAGE INVALID
SDO_TPIDX SYS PACKAGE INVALID
MDPRVT_IDX SYS PACKAGE BODY INVALID
PRVT_IDX SYS PACKAGE BODY INVALID
SDO_TPIDX SYS PACKAGE BODY INVALID
SDO_INDEX_METHOD_10I SYS TYPE BODY INVALID
SDO_GEOM SYS PACKAGE BODY INVALID
SDO_3GL SYS PACKAGE BODY INVALID
SDO_UTIL SYS PACKAGE BODY INVALID
SDO_JOIN SYS FUNCTION INVALID

Changes

Cause

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