4.1.2.4.1.1 Uploading the Custom PLSQL Extensions as an Archive
This section explains the following questions on Custom PLSQL Extensions – what, how to generate an archive and where to upload the archive.
Custom PLSQL Extensions
Custom PLSQL Extensions here refers to the database objects that users may have created in their On-premises data center on a database schema containing of application objects which were created using the Starter Kit generated using Oracle’s PLSQL Starter Kit User Interface.
Custom database Object Types are limited to the following:
Table 4-4 Database Object Types
| Functions |
| Procedures |
| Packages |
| Views (Materialized Views not Supported) |
| Global Temporary Tables |
| Synonyms |
Generating an Archive
Users are required to use the archive scripts bundled as part of the Starter Kit utility to generate Custom PLSQL extension archive.
For more details on How to Generate Custom PLSQL Extension Archive, see the Installation Guide.
Upload the Archive
Customers are required to use My Oracle Support (MOS) portal and create a Service Request (SR) and upload the Custom PLSQL extension archive.
Table 4-5 SR Details
| Product ID | The Project Name / ID used
while generating the Archive using Starter Kit
Archive scripts
|
Project Name is a argument passed when executing the
archive.sh shell. The project name should
be a valid alpha numeric string.
- Project name can contain alphabets (A-Z, a-z).
- Project name can contain numbers (0-9).
- Spaces are NOT allowed.
- Underscore is allowed. Other special character (other than underscore) are not allowed.
Examples:
Valid project name sample: Project_ALMCS_01
Invalid project name sample: Project ALMCS 01 $@
The project name is an identifier used to tag and logical groups objects for given submission. User can use the same project name when executing the archival process. When the same name is used all objects that are previously submitted using this project name will also be archived.
Archive Submission Service Request Status
SR status to be monitored by the Customers using MOS portal for the archive submitted.