Exporting and importing shared components

You can export a single User type shared component or a group of shared components. A User type shared component is one that has been created by another Oracle Portal developer. A System type shared component is part of the default set of shared components that Oracle Portal provides, and can not be exported. You can export the shared component to another database schema using a SQL script file that you can download to a local directory.

You must have Manage shared component access to export a shared component.

To export a group of shared components:

In the Navigator, navigate to the list of shared component groups. In the Actions column, next to the name of the shared components that you want to export, click Export. The Export Result page displays. Click the here link. A Save As dialog prompts you to save the export script file for the shared components on a local directory. Note: You can only export User type shared components. If there are no User type shared components in the group you are trying to export, a message displays:  No object was exported. Save the script file locally as an ASCII text file with the extension .sql. You can now import the shared components into another database schema.

To export a single shared component:

In the Navigator, navigate to the list of shared component groups. In the Name column, click the name of the shared component group that contains the individual shared component that you want to export. In the Actions column, next to the name of the individual shared component that you want to export, click Export. The Export Result page displays. Note: You can only export User type shared components. Click the here link. A Save As dialog prompts you to save the export script file for the component on a local directory. Save the script file locally as an ASCII text file with the extension .sql. You can now import the shared component into another database schema.

Back to top