The data content of this database provisioning profile is compiled from an export dump created using the Data Pump tool. You can choose to export Schema objects (structure only) or the Schema with data (structure + data).
The table below shows the list of tasks that are involved in creating an empty schema or a schema based on profile.
Table 18-1 Creating Databases Using Database Template
Step | Task | Role |
---|---|---|
1 |
Follow the steps in the Getting Started section to enable DBaaS. |
See Getting Started |
2 |
Create resource providers.
|
|
6 |
Create a database provisioning profile. This step is optional and is required if you are importing schemas from a profile. |
See Creating a Database Provisioning Profile Using Export Schema Objects |
4 |
Configure the request settings. |
|
5 |
Define quotas for each self service user. |
See Defining Quotas |
7 |
Create as service template based on:
|
|
8 |
Configure the Chargeback Service. |
|
9 |
While creating a database, select the service template (associated with the database template based profile) you have created. |
You must create one or more resource providers which include:
PaaS Infrastructure Zones: See Creating a PaaS Infrastructure Zone
Schema Pool: See Creating a Database Pool for Schema as a Service
You can configure the request settings by specifying when a request can be made, its duration, and so on. See Configuring Request Settings
After configuring the request settings, you must define quotas for each self service user. See Setting Up Quotas
Optionally, you can configure the chargeback service. See Chargeback Administration.
The self service user can now select the service template based on the database template profile and create a database. See Requesting a Schema.