Skip to Content
0
Oct 19, 2010 at 02:15 PM

SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID'; = 39 rows .

1911 Views

We just applied "SAP Bundle Patch 10.2.0.4.5 - 201010" in our development system.

We completed all the post installation activities.

In tail end - when we execute subjected command, 39 rows returned.

Very First --- May we understand What is the negative impact on Oracle system?

Secondly -- Do we need to make these rows to "ZERO" is must ?

Finally - How to make them to "ZERO"

2 lines expert advise...will enable us to move forward.

Rgds

==========

COMMAND

==========

SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

OBJECT_NAME

-


LOGMNR_KRVRDLUID3

DBMS_SQLTCB_INTERNAL

DBMS_LOGMNR_FFVTOLOGMNRT

DBMS_LOGMNR_OCTOLOGMNRT

DBMS_RULE_EXP_UTL

DBMS_LOGSTDBY

DBMS_AW_EXP

DBMS_SNAP_INTERNAL

DBMSOBJG_DP

DBMS_REPCAT_EXP

DBMS_STREAMS_TBS_INT_INVOK

DBMS_FILE_GROUP_UTL

DBMS_FILE_GROUP_UTL_INVOK

DBMS_STREAMS_MT

DBMS_LOGREP_EXP

DBMS_LOGREP_IMP

DBMS_STREAMS_RPC

DBMS_STREAMS_DATAPUMP

DBMS_STREAMS_DATAPUMP_UTIL

DBMS_STREAMS_TBS_INT

DBMS_STREAMS_TBS_INT_INVOK

DBMS_STREAMS_TABLESPACE_ADM

DBMS_FILE_GROUP_UTL

DBMS_FILE_GROUP_UTL_INVOK

DBMS_FILE_GROUP

DBMS_FILE_GROUP_INTERNAL_INVOK

DBMS_FILE_GROUP_EXP

DBMS_FILE_GROUP_IMP_INTERNAL

DBMS_REDEFINITION

DBMS_CDC_DPUTIL

LOGMNR_KRVRDREPDICT3

DBMS_CDC_DPUTIL

DBMS_CDC_EXPDP

DBMS_CDC_EXPVDP

DBMS_CDC_IMPDP

DBMS_SCHEMA_COPY

UTL_RECOMP

DBMS_SQLTUNE_INTERNAL

DBMS_CDC_DPUTIL

39 rows selected.

SQL>

==========