To configure seamless access, you must create views and synonyms in the database. If your policies do not allow external applications to create database objects, use the Create Seamless Data Access Script standalone job to create a script that you can review and then run on the database. The script includes statements to create the required views and synonyms for seamless access.

When you run the job, the job creates a script and stores the script in the location that you specified in the job parameters. The job uses the following naming convention to create the script file:

SEAMLESS_ACCESS_<Job ID>.SQL

The job uses the parameters that you specify to create the script statements. The script can include statements to create one of the following seamless access views:

Combined view of the production and archived data.
Query view of the archived data.

The script generates statements for the schema that you provide in the job parameters. You can enter the combined schema or the query schema. For example, if you provide the combined schema, then the script includes statements to create the views and synonyms for the combined seamless access view.

If you want to create both the combined view and the query view, run the job once for each schema.