Once I add the priv to the upgrade user. How can I resolve this? Do I
have to rerun the catalog upgrade script?
takesiro wrote:
> 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 - 15:39:18 CDT
