|
If your provider implementation does not exist in a same schema as Oracle
Portal, use provsyns.sql to associate the provider schema with
the Portal schema.
To drop synonyms that reference Portal objects, use provsynr.sql.
|
Version: Oracle9iAS Portal
9.0.2
|
|
Provider schema synonym script names and descriptions
|
|
provsynr.sql
|
Drops private synonyms in a provider schema that reference Portal
objects.
Run this script if you want to associate a provider schema with
a new Portal schema. After
running this script, you can run provsyns.sql (detailed below) to
associate the provider schema with a new Portal schema.
Note: Only an Provider schema owner can submit this script.
For example,
- Logon to SQLPLUS as the Provider schema owner: sqlplus provider/provider
- In SQLPLUS, type: @provsynr.sql
|
|
provsyns.sql
|
Creates synonyms for Portal objects so that a provider implementation
can exist in a different
schema from that of Oracle Portal.
Run this script to associate a provider schema with the new Portal
schema.
Note: Only a Portal schema owner can submit this script.
For example,
- Logon to SQLPLUS as the Portal schema owner: sqlplus portal/portal
- In SQLPLUS, type: @provsyns.sql <provider_schema>
|
|
