Invalid Objects

From: J Huntley Palmer <jhp_at_dontspam.spam>
Date: Mon, 08 May 2006 22:12:24 -0400
Message-ID: <125vukqjcgqm4c4@news.supernews.com>

After the upgrade to 10.2.0.2 from 10.2.0.1 I was left with these invalid objects that could not be recompiled:

Errors
Failed to compile: ORA-00980: synonym translation is no longer valid

Any help appreciated.

	ALL_OLAP2_AW_CATALOGS	SYNONYM	INVALID
	ALL_OLAP2_AW_CATALOG_MEASURES	SYNONYM	INVALID
	ALL_OLAP2_AW_PHYS_OBJ	SYNONYM	INVALID
	ALL_OLAP2_AW_PHYS_OBJ_PROP	SYNONYM	INVALID
	ALL_OLAP2_AW_DIMENSIONS	SYNONYM	INVALID
	ALL_OLAP2_AW_ATTRIBUTES	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBES	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_DIM_USES	SYNONYM	INVALID
	ALL_AW_DIM_ENABLED_VIEWS	SYNONYM	INVALID
	ALL_AW_CUBE_ENABLED_VIEWS	SYNONYM	INVALID
	ALL_AW_CUBE_ENABLED_HIERCOMBO	SYNONYM	INVALID
	ALL_OLAP2_AW_DIM_LEVELS	SYNONYM	INVALID
	ALL_OLAP2_AW_DIM_HIER_LVL_ORD	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_MEASURES	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_AGG_SPECS	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_AGG_MEAS	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_AGG_LVL	SYNONYM	INVALID
	ALL_OLAP2_AW_CUBE_AGG_OP	SYNONYM	INVALID
	MRV_OLAP2_AW_DIMENSIONS	SYNONYM	INVALID
	MRV_OLAP2_AW_ATTRIBUTES	SYNONYM	INVALID
	MRV_OLAP2_AW_CUBES	SYNONYM	INVALID
	MRV_OLAP2_AW_CUBE_MEASURES	SYNONYM	INVALID
	OLAP_SYS_AW_ACCESS_CUBE_VIEW	SYNONYM	INVALID
	OLAP_SYS_AW_ACCESS_DIM_VIEW	SYNONYM	INVALID
	OLAP_SYS_AW_ENABLE_ACCESS_VIEW	SYNONYM	INVALID
	CWM2_OLAP_OLAPAPI_ENABLE	PACKAGE BODY	INVALID
	DBMS_AWM	PACKAGE BODY	INVALID
	CWM2_OLAP_CUBE	PACKAGE BODY

Received on Mon May 08 2006 - 21:12:24 CDT