Skip to Content
-2

Need help with Public synonym

Jan 24 at 11:39 PM

28

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers