Thursday, April 12, 2018

ALTER SESSION SET CURRENT_SCHEMA


You can use below command to avoid the use of public synonyms.  By setting the current_schema attribute to the schema owner name it is not necessary to create public synonyms for production table names

ALTER SESSION SET CURRENT_SCHEMA = "XX_SCHEMA_NAME"

Ex:  ALTER SESSION SET CURRENT_SCHEMA = "APPS"

No comments:

Post a Comment

Unix commands to get the count of files

 ls -l *.rdf | wc -l