Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid synonyms

GTS (DBA)Oct 10 2015 — edited Oct 10 2015

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

This post has been answered by unknown-698157 on Oct 10 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2015
Added on Oct 10 2015
4 comments
2,391 views