O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Best practice – using the Staging Area User to access your target schema

Of all the parameters used to define how to connect to a database schema, the Work Schema parameter is probably the most crucial, even though many people do not understand the signification and importance of carefully selecting a proper schema. This is what we will focus on in this recipe.

Getting ready

To be able to execute this recipe, you will need to have enough privileges to create a new user in the database. For an Oracle database, this means that you need to be able to connect to the database with a user that has the CREATE USER and ADMIN OPTION privileges. If you are using a user that has the DBA privilege, you will have these privileges automatically.

How to do it... ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required