Hi all
It's test scenario. Jst downgraded my database to 10.2.0.5 from 11g.
I have invalid synonnyms. How can i make as 'VALID';
These are not workable.
SQL> alter synonym <synonym_name> compile;
SQL> alter public synonym <synonym_name> compile;
SQL>@?/rdbms/admin/utlrp.sql;
SQL> select object_name,status, object_type,created from dba_objects where status='INVALID';
OBJECT_NAME STATUS OBJECT_TYPE CREATED
------------------------------------------ ------- ------------------- ---------
MGMT_TARGET_BLACKOUTS INVALID SYNONYM 09-OCT-15
SETEMVIEWUSERCONTEXT INVALID SYNONYM 09-OCT-15
MGMT$ALERT_CURRENT INVALID SYNONYM 09-OCT-15
MGMT$ALERT_HISTORY INVALID SYNONYM 09-OCT-15
MGMT$AVAILABILITY_CURRENT INVALID SYNONYM 09-OCT-15
MGMT$AVAILABILITY_HISTORY INVALID SYNONYM 09-OCT-15
MGMT$BLACKOUT_HISTORY INVALID SYNONYM 09-OCT-15
MGMT$CLUSTER_INTERCONNECTS INVALID SYNONYM 09-OCT-15
MGMT$CSA_CLIENTS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_COOKIES INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_CPUS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_CUSTOM INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_IOCARDS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_NICS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_OS_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_OS_FILESYSTEMS INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_OS_PROPERTIES INVALID SYNONYM 09-OCT-15
MGMT$CSA_HOST_SW INVALID SYNONYM 09-OCT-15
MGMT$DB_CONTROLFILES INVALID SYNONYM 09-OCT-15
MGMT$DB_DATAFILES INVALID SYNONYM 09-OCT-15
MGMT$DB_DBNINSTANCEINFO INVALID SYNONYM 09-OCT-15
MGMT$DB_FEATUREUSAGE INVALID SYNONYM 09-OCT-15
MGMT$DB_INIT_PARAMS INVALID SYNONYM 09-OCT-15
MGMT$DB_LICENSE INVALID SYNONYM 09-OCT-15
MGMT$DB_REDOLOGS INVALID SYNONYM 09-OCT-15
MGMT$DB_ROLLBACK_SEGS INVALID SYNONYM 09-OCT-15
MGMT$DB_SGA INVALID SYNONYM 09-OCT-15
MGMT$DB_TABLESPACES INVALID SYNONYM 09-OCT-15
MGMT$DELTA_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_COMPONENT_DETAILS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_FS_MOUNT INVALID SYNONYM 09-OCT-15
MGMT$DELTA_HARDWARE INVALID SYNONYM 09-OCT-15
MGMT$DELTA_HOST_CONFIG INVALID SYNONYM 09-OCT-15
MGMT$DELTA_INIT INVALID SYNONYM 09-OCT-15
MGMT$DELTA_ONEOFF_PATCHES INVALID SYNONYM 09-OCT-15
MGMT$DELTA_ORACLE_HOME INVALID SYNONYM 09-OCT-15
MGMT$DELTA_OS_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_OS_COMP_DETAILS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_OS_KERNEL_PARAMS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_PATCHSETS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_PATCHSET_DETAILS INVALID SYNONYM 09-OCT-15
MGMT$DELTA_VENDOR_SW INVALID SYNONYM 09-OCT-15
MGMT$DELTA_VIEW INVALID SYNONYM 09-OCT-15
MGMT$DELTA_VIEW_DETAILS INVALID SYNONYM 09-OCT-15
MGMT$ECM_CURRENT_SNAPSHOTS INVALID SYNONYM 09-OCT-15
MGMT$ECM_VISIBLE_SNAPSHOTS INVALID SYNONYM 09-OCT-15
MGMT$GROUP_DERIVED_MEMBERSHIPS INVALID SYNONYM 09-OCT-15
MGMT$GROUP_FLAT_MEMBERSHIPS INVALID SYNONYM 09-OCT-15
MGMT$GROUP_MEMBERS INVALID SYNONYM 09-OCT-15
MGMT$HA_BACKUP INVALID SYNONYM 09-OCT-15
MGMT$HA_FILES INVALID SYNONYM 09-OCT-15
MGMT$HA_INFO INVALID SYNONYM 09-OCT-15
MGMT$HA_INIT_PARAMS INVALID SYNONYM 09-OCT-15
MGMT$HA_MTTR INVALID SYNONYM 09-OCT-15
MGMT$HA_RMAN_CONFIG INVALID SYNONYM 09-OCT-15
MGMT$HW_NIC INVALID SYNONYM 09-OCT-15
MGMT$INTERFACE_STATS INVALID SYNONYM 09-OCT-15
MGMT$METRIC_COLLECTION INVALID SYNONYM 09-OCT-15
MGMT$METRIC_CURRENT INVALID SYNONYM 09-OCT-15
MGMT$METRIC_DAILY INVALID SYNONYM 09-OCT-15
MGMT$METRIC_DETAILS INVALID SYNONYM 09-OCT-15
MGMT$METRIC_HOURLY INVALID SYNONYM 09-OCT-15
MGMT$MISSING_TARGETS INVALID SYNONYM 09-OCT-15
MGMT$MISSING_TARGETS_IN_GROUPS INVALID SYNONYM 09-OCT-15
MGMT$OS_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$OS_FS_MOUNT INVALID SYNONYM 09-OCT-15
MGMT$OS_HW_SUMMARY INVALID SYNONYM 09-OCT-15
MGMT$OS_KERNEL_PARAMS INVALID SYNONYM 09-OCT-15
MGMT$OS_PATCHES INVALID SYNONYM 09-OCT-15
MGMT$OS_SUMMARY INVALID SYNONYM 09-OCT-15
MGMT$RACDB_INTERCONNECTS INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_COMPONENT_ONEOFF INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_COMP_PATCHSET INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_DEPENDENCIES INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_HOMES INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_ONEOFF_PATCHES INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_OTHERS INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_PATCHES_IN_HOMES INVALID SYNONYM 09-OCT-15
MGMT$SOFTWARE_PATCHSETS INVALID SYNONYM 09-OCT-15
MGMT$TARGET INVALID SYNONYM 09-OCT-15
MGMT$TARGET_COMPONENTS INVALID SYNONYM 09-OCT-15
MGMT$TARGET_COMPOSITE INVALID SYNONYM 09-OCT-15
MGMT$TARGET_PROPERTIES INVALID SYNONYM 09-OCT-15
MGMT$TARGET_TYPE INVALID SYNONYM 09-OCT-15
MGMT$E2E_1DAY INVALID SYNONYM 09-OCT-15
MGMT$E2E_HOURLY INVALID SYNONYM 09-OCT-15
MGMT$E2E_RAW INVALID SYNONYM 09-OCT-15
MGMT$TXN_PERF_RAW INVALID SYNONYM 09-OCT-15
MGMT$TXN_PERF_HOUR INVALID SYNONYM 09-OCT-15
MGMT$TXN_PERF_DAY INVALID SYNONYM 09-OCT-15
MGMT$STEPS INVALID SYNONYM 09-OCT-15
MGMT$STEP_GROUPS INVALID SYNONYM 09-OCT-15
MGMT$STEP_METRICS_RAW INVALID SYNONYM 09-OCT-15
MGMT$GRP_METRICS_RAW INVALID SYNONYM 09-OCT-15
MGMT$STEP_METRICS_HOURLY INVALID SYNONYM 09-OCT-15
MGMT$GRP_METRICS_HOURLY INVALID SYNONYM 09-OCT-15
MGMT$STEP_METRICS_DAILY INVALID SYNONYM 09-OCT-15
MGMT$GRP_METRICS_DAILY INVALID SYNONYM 09-OCT-15
MGMT_VIEW_UTIL INVALID SYNONYM 09-OCT-15
MGMT_MESSAGES INVALID SYNONYM 09-OCT-15
MGMT_PAF_PROCS_LATEST INVALID SYNONYM 09-OCT-15
MGMT_PAF_JOBS INVALID SYNONYM 09-OCT-15
MGMT_PAF$PROCEDURES INVALID SYNONYM 09-OCT-15
MGMT_PAF$INSTANCES INVALID SYNONYM 09-OCT-15
MGMT_PAF$STATES INVALID SYNONYM 09-OCT-15
MGMT_PAF$APPLICATIONS INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY1 INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY2 INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY3 INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY4 INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY5 INVALID SYNONYM 09-OCT-15
MGMT$ECM_CONFIG_HISTORY_KEY6 INVALID SYNONYM 09-OCT-15
MGMT_IP_TGT_GUID_ARRAY INVALID SYNONYM 09-OCT-15
115 rows selected.
DB : 10.2.0.5 on redhat