Database Administration (MOSC)

MOSC Banner

Invalid objects 11G (SPATIAL)

Dear Communitie,

I have some invalid objects in one of my databases v. 11.1.0.7.0. What will be the best option to solve them? Compile them?

Thanks

SYS 	
	FUNCTION 	QRY2OPT				INVALID  
			SDO_PQRY 			INVALID  
			SDO_SIMPLE_FILTER 		INVALID  
  	PACKAGE 	PRVT_IDX 			INVALID  
			SDO_3GL 			INVALID  
  	PACKAGE BODY 	MDPRVT_IDX 			INVALID  
			PRVT_IDX 			INVALID  
			SDO_3GL 			INVALID  
			SDO_GEOM 			INVALID  
			DO_TPIDX 			INVALID  
  	TYPE BODY 	SDO_INDEX_METHOD_10I 		INVALID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center