Create a PDB With Data

You can create a PDB with data by following these instructions:

Pluggable databases with data can be created using service templates. To create a service template for PDB as a service, follow these steps:

1. Log into Enterprise Manager as a user with the EM_SSA_ADMINISTRATOR role.
2. From the Enterprise menu, select Cloud, then select Cloud Home. The Cloud Home page appears. From the Oracle Cloud menu, select Setup, then select Getting Started.
3. Click the Setup link next to the Databases option in the left panel. Select Pluggable Database from the drop down menu.
4. Click the Service Templates link. The Service Templates page appears. Click Create. The Create Service Template: General page appears.
5. Enter a name and description for the service template. The description must be unique and provide information on the type of service template being created.
6. In the Pluggable Database region, select the Create Pluggable Databases from Profile option and select a database provisioning profile that is to be used to create the pluggable database.
7. Click the Search icon next to the Profile field and select a profile from the list. If a profile does not exist, you must create one.
8. In the Pools and Zones region, click Add to select a PaaS Infrastructure Zone into which the pluggable database instance is to be provisioned. Click Assign Pool to add a Database Pool (for Pluggable Databases) for the zone.

   Note:

   A database pool (for PDBs) must be present in the PaaS Infrastructure Zone that you select here.
9. After the database pool has been assigned, the container database into which the pluggable database is to be added is displayed in the Reference Container Database field. All the validations for the service template will be performed against this database.
10. Select Create Pluggable Databases from Profile in the Pluggable Database region, in the Shared Location field specify the Path or the shared location on all hosts in which the schema dumps are present. The Dump File Location must be accessible by all the databases.
11. In the Placement region, the pluggable database can be provisioned on the container database using one of the following options: Selected by placement algorithm or Selected by user during request.
12. In the Identification region, in the Pluggable Database Prefix Name field, specify the prefix that is to be used to generate a unique Pluggable Database name at the time of database creation. The prefix helps to identify the PDBs that are created using this service template.
13. Click Next. The Create New Service Template: Configurations page appears.
14. Click Next. The Create Service Template: Initialization Parameters page appears. In this page, you can configure the values of various initialization parameters that affect the operation of the database instance.
15. Click Next. The Create Service Template: Customization page appears. Specify the custom scripts that need to be executed before and after the database is created.
16. In the Target Properties region, you can specify global target properties such as Location, Department, Line of Business, and so on. You can mark a property as mandatory or lock a property.
17. Click Next. The Create Service Template: Roles page appears. Click Add to select the EM_SSA_USER roles to which this service template will be available. All users belonging to the selected role can use this service template.
18. Click Next. The Create Service Template: Review page appears where you can review the details entered so far.
19. Click Submit. The newly created service template will appear in the Database Cloud Self Service Portal Setup: Service Templates page. You can click on the Service Template Name link to view additional details.

For more information and a complete detailed set of steps and options see: Creating a Service Template for PDB Based on Profile.