| Provider schema synonym scripts

Related topics

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>

Related topics
Provider API packages scripts | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio