Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
While exporting the SYNONYM from oracle the VIEW DDLs have the some other objects in select statement on which the view is created and those objects contain the full object name including schema-name same as Oracle.
Example -
DDL used on Oracle on Schema TEST:
CREATE OR REPLACE SYNONYM offices for locations;
Exported DDL:
CREATE OR REPLACE VIEW offices AS SELECT * FROM test.locations;
darold
commented
1 year ago
While exporting the SYNONYM from oracle the VIEW DDLs have the some other objects in
selectstatement on which the view is created and those objects contain the full object name including schema-name same as Oracle. Example - DDL used on Oracle on Schema TEST:Exported DDL:
Thanks for the help in advance.