Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Syntax Conversion/ From Oracle to GaussDB
Updated on 2025-06-07 GMT+08:00
View PDF
Share

From Oracle to GaussDB

GaussDB supports only common synonyms and does not support public synonyms. UGO will convert public synonyms in an Oracle database to common synonyms of the public schema in a GaussDB database. For details, see Table 1.

If different users in your database have public synonyms with the same name, there are synonym conflicts. You need to reconstruct the synonyms with the same name before migrating them. For details, see Table 2.

Table 1 Syntax conversion 1

Source SQL in Oracle

Converted SQL in GaussDB

CREATE PUBLIC SYNONYM u1.syn FOR u1.object1;

CREATE SYNONYM public.syn FOR u1.object;
Table 2 Syntax conversion 2

Source SQL in Oracle

Converted SQL in GaussDB

Whether Synonyms Conflict

CREATE PUBLIC SYNONYM u1.syn FOR u1.object1;

CREATE SYNONYM public.syn FOR u1.object1;

No

CREATE PUBLIC SYNONYM u2.syn FOR u1.object2;

CREATE SYNONYM public.syn FOR u2.object2;

Yes
Parent topic: Syntax Conversion