Migrating Synonyms Data Using ADS Definition

Oracle delivers an ADS definition to copy or migrate synonym metadata from one environment to another.

For information on using ADS, see Lifecycle Management Guide: Understanding ADS Projects.

ADS Definition for Synonyms

ADS definition for synonyms —PTSF_SYNONYMS.

PTSF_SYNONYM_GROUP

Details of PTSF_SYNONYM_GROUP:

Group Details

Group Name

PTSF_SYNONYM_GROUP

Group Description

Group for PTSF_SYNONYM

Group Members

PTSFSYNONYMS.PTSF_SYN_ENABLED

Group Properties

Merge configurations.

Tables for PTSF_SYNONYMS

Table Description

PTSFSYNONYMS

Stores synonyms data.

PTSFSYNONYMLANG

Stores translated synonyms data.