My Oracle Support Banner

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

Last updated on AUGUST 13, 2018

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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