DBCA Database Template Window

The Database Configuration Assistant (DBCA) Database Template window enables you to select the type of database template to use to create the database. You can select:

• General Purpose or Transaction Processing

• Custom Database

• Data Warehouse

Oracle Enterprise Manager Database Express (EM Express) supports Oracle single instance databases, including non-CDBs, multitenant container databases (CDBs), and pluggable databases (PDBs).

You can use DBCA to create a database from templates supplied by Oracle or from templates that you create. The templates contain settings optimized for a particular type of workload.

Oracle ships templates for the following two workload types:

• General purpose or transaction processing

• Data warehouse

Select the template suited to the type of workload your database will support. If you are not sure which to choose, then select the default General Purpose or Transaction Processing template.

For more complex environments, you can select the Custom Database option. This option does not use templates and results in a more extensive interview, which means that it takes longer to create your database.