| INVALID Objects [message #446065] |
Fri, 05 March 2010 06:20  |
oracleraj
Messages: 13
Registered: November 2009
|
Junior Member |
|
|
SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS from user_objects where status = 'INVALID';
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
GET_MAX_CHECKPOINT FUNCTION INVALID
DBA_LOGMNR_LOG VIEW INVALID
DBA_LOGMNR_SESSION VIEW INVALID
DBMS_LOGMNR_INTERNAL PACKAGE BODY INVALID
LOGMNR_KRVRDLUID3 PROCEDURE INVALID
LOGMNR_KRVRDREPDICT3 PROCEDURE INVALID
DBMS_LOGMNR_FFVTOLOGMNRT PROCEDURE INVALID
LOGMNR_KRVRDA_TEST_APPLY PROCEDURE INVALID
DBMS_LOGMNR_OCTOLOGMNRT PROCEDURE INVALID
DBA_LOGMNR_PURGED_LOG VIEW INVALID
LOGMNR_DICT_CACHE PACKAGE BODY INVALID
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
DBMS_LOGMNR_SESSION PACKAGE BODY INVALID
LOGSTDBY_LOG VIEW INVALID
DBA_LOGSTDBY_PROGRESS VIEW INVALID
DBA_LOGSTDBY_LOG VIEW INVALID
DBMS_LOGSTDBY PACKAGE BODY INVALID
DBMS_INTERNAL_LOGSTDBY PACKAGE BODY INVALID
DBA_CAPTURE VIEW INVALID
ALL_CAPTURE VIEW INVALID
ALL_CAPTURE_PARAMETERS VIEW INVALID
ALL_CAPTURE_EXTRA_ATTRIBUTES VIEW INVALID
DBA_REGISTERED_ARCHIVED_LOG VIEW INVALID
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
_ALL_STREAMS_PROCESSES VIEW INVALID
ALL_STREAMS_GLOBAL_RULES VIEW INVALID
ALL_STREAMS_SCHEMA_RULES VIEW INVALID
ALL_STREAMS_TABLE_RULES VIEW INVALID
ALL_STREAMS_MESSAGE_RULES VIEW INVALID
ALL_STREAMS_RULES VIEW INVALID
DBMS_LOGMNR_LOGREP_DICT PACKAGE BODY INVALID
DBMS_STREAMS_ADM_UTL PACKAGE BODY INVALID
DBMS_STREAMS_ADM PACKAGE BODY INVALID
DBMS_CAPTURE_ADM_INTERNAL PACKAGE BODY INVALID
DBMS_CAPTURE_PROCESS PACKAGE BODY INVALID
OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
DBMS_LOGREP_UTIL PACKAGE BODY INVALID
34 rows selected.
How can I make them VALID Objects, I have tried to recompile them but but failed....
|
|
|
|
| Re: INVALID Objects [message #446068 is a reply to message #446065] |
Fri, 05 March 2010 06:25  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi,
Can you please post what kind of error you are getting when you try to compile these objects.
The reason of the error might be because the base object of invalid object's might not be correct or might not exists.
You can run $ORACLE_HOME/rdbms/admin/utlrp.sql file to compile the invalid objects of the database and then compare the count of invalid objects.
Regards
Lalit
|
|
|
|
|
|
| Re: INVALID Objects [message #446086 is a reply to message #446074] |
Fri, 05 March 2010 07:10 |
oracleraj
Messages: 13
Registered: November 2009
|
Junior Member |
|
|
When I do full DB export I get below errors in my log file... the export terminates sussesfully with warnings....message in log file... some one told me because of Invalid objects in DB.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2625
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2625
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL 0 rows exported
|
|
|
|
|
|
| Re: INVALID Objects [message #446146 is a reply to message #446107] |
Fri, 05 March 2010 13:28 |
John Watson
Messages: 8938
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I would guess that at some point you upgraded from 9i to 10g. There are many bugs logged in Metalink regarding the upgrade of Streams, and all your invalid objects are related to Streams.
If you aren't using Streams, the errors don't matter - just ignore them.
[Updated on: Fri, 05 March 2010 14:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
