Need help with Public synonym

[former_member198680]

Hello,

I am working on a table function. During transport, have issues with the select statements as the tables are referring to DEV schema. Have to handle DEV schema when this function is transported across landscape.

Opt 1 - Have tried adding DEFAULT SCHEMA "DEV" but it is giving syntax error and could not resolve.

Opt 2 - Want to create public synonyms and replace the select on tables with synonyms.

Need help to understand how to create the public synonyms? Do we have to execute the SQL statement to create public synonym with corresponding schema in each system SQL console (DEV, TEST, PRD) or is there a way to transport?

Thanks in Advance.

Prasad