Wednesday, May 29, 2013

How to uninstall/remove invalid OLAP components since OLAP Oracle binary not installed

SQL> select comp_id,comp_name,version from dba_registry where status='INVALID';

COMP_ID         COMP_NAME                 VERSION
--------------- ------------------------- --------------------
APS             OLAP Analytic Workspace   11.2.0.3.0
XOQ             Oracle OLAP API           11.2.0.3.0
AMD             OLAP Catalog              11.2.0.3.0


Short Steps:

oracle@solaris11:~$ sqlplus / as sysdba

----> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql
----> Remove OLAP API
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoxoq.sql
----> Deinstall APS - OLAP AW component
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/cwm2drop.sql
----> Recompile invalids
SQL> @?/rdbms/admin/utlrp.sql


Detail Steps:

SQL> ----> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql

oracle@solaris11:~$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 29 22:53:27 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SQL> ----> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql

Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Package dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


Synonym dropped.


User dropped.


Role dropped.

SQL> ----> Remove OLAP API
SQL> @?/olap/admin/olapidrp.plb

Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.

SQL> @?/olap/admin/catnoxoq.sql

Package dropped.


Package dropped.


Type dropped.


Type dropped.


Sequence dropped.


Type dropped.


Synonym dropped.


Procedure dropped.


Synonym dropped.


Function dropped.


Library dropped.


Type dropped.


Type dropped.


Type dropped.


Type dropped.


Package dropped.


Package dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Sequence dropped.


Library dropped.

DROP PUBLIC SYNONYM GV_Olapi_Session_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM V_Olapi_Session_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM GV_Olapi_Iface_Object_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM V_Olapi_Iface_Object_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM GV_Olapi_Iface_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM V_Olapi_Iface_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM GV_Olapi_Memory_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM V_Olapi_Memory_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM GV_Ksmhp FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_History_Seq FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_Session_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_Iface_Object_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_Iface_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_Memory_Op_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM Olapi_Memory_Heap_History FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM DBMS_XSOQ FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP PUBLIC SYNONYM DBMS_XSOQ_UTIL FORCE
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


DROP VIEW GV_Olapi_Session_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW V_Olapi_Session_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW GV_Olapi_Iface_Object_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW V_Olapi_Iface_Object_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW GV_Olapi_Iface_Op_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW V_Olapi_Iface_Op_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW GV_Olapi_Memory_Op_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW V_Olapi_Memory_Op_History
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW GV_Ksmhp
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP SEQUENCE Olapi_History_Seq
              *
ERROR at line 1:
ORA-02289: sequence does not exist


DROP TABLE Olapi_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE Olapi_Session_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE Olapi_Iface_Object_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE Olapi_Iface_Op_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE Olapi_Memory_Op_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE Olapi_Memory_Heap_History CASCADE CONSTRAINTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP PROCEDURE OlapiHistoryRetention
*
ERROR at line 1:
ORA-04043: object OLAPIHISTORYRETENTION does not exist


DROP TRIGGER OlapiStartupTrigger
*
ERROR at line 1:
ORA-04080: trigger 'OLAPISTARTUPTRIGGER' does not exist


DROP TRIGGER OlapiShutdownTrigger
*
ERROR at line 1:
ORA-04080: trigger 'OLAPISHUTDOWNTRIGGER' does not exist


DROP PACKAGE DBMS_XSOQ
*
ERROR at line 1:
ORA-04043: object DBMS_XSOQ does not exist


DROP PACKAGE DBMS_XSOQ_UTIL
*
ERROR at line 1:
ORA-04043: object DBMS_XSOQ_UTIL does not exist



PL/SQL procedure successfully completed.


Synonym dropped.


Package dropped.

  DROP PACKAGE GenDatabaseInterface
*
ERROR at line 1:
ORA-04043: object GENDATABASEINTERFACE does not exist


  DROP PACKAGE GenConnectionInterface
*
ERROR at line 1:
ORA-04043: object GENCONNECTIONINTERFACE does not exist


  DROP PACKAGE GenServerInterface
*
ERROR at line 1:
ORA-04043: object GENSERVERINTERFACE does not exist


  DROP PACKAGE GenMdmPropertyIdConstants
*
ERROR at line 1:
ORA-04043: object GENMDMPROPERTYIDCONSTANTS does not exist


  DROP PACKAGE GenMdmClassConstants
*
ERROR at line 1:
ORA-04043: object GENMDMCLASSCONSTANTS does not exist


  DROP PACKAGE GenMdmObjectIdConstants
*
ERROR at line 1:
ORA-04043: object GENMDMOBJECTIDCONSTANTS does not exist


  DROP PACKAGE GenMetadataProviderInterface
*
ERROR at line 1:
ORA-04043: object GENMETADATAPROVIDERINTERFACE does not exist


  DROP PACKAGE GenCursorManagerInterface
*
ERROR at line 1:
ORA-04043: object GENCURSORMANAGERINTERFACE does not exist


  DROP PACKAGE GenDataTypeIdConstants
*
ERROR at line 1:
ORA-04043: object GENDATATYPEIDCONSTANTS does not exist


  DROP PACKAGE GenDefinitionManagerInterface
*
ERROR at line 1:
ORA-04043: object GENDEFINITIONMANAGERINTERFACE does not exist


  DROP PACKAGE GenDataProviderInterface
*
ERROR at line 1:
ORA-04043: object GENDATAPROVIDERINTERFACE does not exist



PL/SQL procedure successfully completed.


Procedure dropped.


Function dropped.


Package dropped.


PL/SQL procedure successfully completed.


1 row deleted.

SQL> ----> Deinstall APS - OLAP AW component
SQL> @?/olap/admin/catnoaps.sql

Procedure created.


PL/SQL procedure successfully completed.


Procedure dropped.


1 row deleted.

SQL> @?/olap/admin/cwm2drop.sql
drop public synonym cwm2_olap_exceptions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_manager
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_utility
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_catalog
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_cube
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_dimension
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_dimension_attribute
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_hierarchy
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_level
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_level_attribute
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_measure
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_validate
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_verify_access
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_export
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_delete
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_table_map
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_pc_transform
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_security
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dbms_aw_utilities
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_dim_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_dim_levels
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym cwm2_olap_classify
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_cubes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_cube_measures
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_cube_dim_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_cube_meas_dim_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_hierarchies
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_levels
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_hier_level_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_attr_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_level_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_cube_measure_maps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_fact_level_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_level_key_col_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_join_key_column_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_level_attr_maps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_catalogs
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_entity_desc_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_catalog_entity_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_fact_table_gid
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_hier_custom_sort
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olapmr_facttblkeymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olapmr_facttblfctmaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_listdims
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_hiers
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_hierdims
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_FactTblKeyMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_rufcttblkyMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_FactTblFctMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_hierdim_keycol_map
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olapmr_dim_levels_keymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_dim_levels_keymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_mr_measdimview
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap9i1_hier_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap9i2_hier_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap1_cubes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_entity_parameters
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym dba_olap2_entity_ext_parms
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_cubes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_cube_measures
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_cube_dim_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_cube_meas_dim_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_hierarchies
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_levels
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_hier_level_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_attr_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_level_attributes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_cube_measure_maps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_fact_level_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_level_key_col_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_join_key_column_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_level_attr_maps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_catalogs
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_entity_desc_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_catalog_entity_uses
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_fact_table_gid
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_hier_custom_sort
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_facttblkeymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_facttblfctmaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_listdims
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_hiers
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_hierdims
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_FactTblKeyMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_rufcttblkyMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_FactTblFctMaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_hierdim_keycol_map
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olapmr_dim_levels_keymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_dim_levels_keymaps
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_mr_measdimview
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap9i1_hier_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap9i2_hier_dimensions
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap1_cubes
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_entity_parameters
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop public synonym all_olap2_entity_ext_parms
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


SQL> ----> Recompile invalids
SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2013-05-29 23:00:29

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2013-05-29 23:00:31

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

SQL> select comp_id,comp_name,version from dba_registry where status='INVALID';

no rows selected