database schema

[brian]

Is there any way that I can select or choose database schemas at run time ???

Thanks.

 

[jpickup]

The database schema depends on your login user. To the best of my knowledge it is not possible to select a particular schema for a given user.

Objects in other schemas are accessed by prefixing the object with the schema name, i.e. schemaname.objectname

Public synonyms are very usefull if you wish to make objects in one schema visible in all others.

 

[JohnYoung]

try alter session set current_schema=SpecifiedSchema after application logon.
don't use public synonym,it is slow.