PL/SQL (MOSC)

MOSC Banner

mapping using SYNONYMs

edited Dec 3, 2015 8:16PM in PL/SQL (MOSC) 3 commentsAnswered ✓

I have the follwing situation: A vendor application running on the client side is using OCI and also  .NET data provider.

The application is written such that it is using a fixed table owner prefix, name it VENDOR. So there exists a user VENDOR in the databse instance of

the Oracle server.

Now the requirement is brought to the vendor by one of his customers, to allow multiple schemata existing in parallel in one instance.

Since the name "VENDOR" can only be unique in one instance, I'm asking how it could be possibly mapped by using SYNONYMS.

I'm thinking of creating users (schema-owners) VENDOR001, VENDOR 002 etc., each one creating the schema under his name (VENDOR001,..002 etc.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center