Re: Invalid Objects

Please check below
"The OLAP Catalog tables are owned by OLAPSYS. To create OLAP metadata in these tables, the user must have the OLAP_DBA role"

Upgrade user didn't have OLAP_SYS when upgrade.

Regards.

"J Huntley Palmer" <jhp_at_dontspam.spam> wrote in message news:125vukqjcgqm4c4_at_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 Tue May 09 2006 - 07:05:32 CDT