SQL Language (MOSC)

MOSC Banner

What schema is a view bound to, when an environment has multiple available?

edited Jun 18, 2020 8:47PM in SQL Language (MOSC) 7 commentsAnswered ✓

I'm in a somewhat unusual situation:  A vendor solution includes a server where different versions and environments exist, simply by existing in different schemas all on a single server.  So for example, where normally you'd have environments on separate servers entirely, the setup includes one server with a  DEVELOPMENT, STAGING, TRAINING, REPORTING, and UTILITIES schema, each of them an image of the an application database, each with it's own unique intended purpose.  The REPORTING schema is the one most used on a day to day basis, and to keep all the versions read only, people who want to write their

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