Database Operations

Use this page to select the database configuration task that you want to perform with Database Configuration Assistant (DBCA). The following table summarizes the tasks that you can select.

Note: Oracle recommends that you close other applications before performing these tasks.

Task Description
Create a Database

This option guides you through the steps of creating a new database or template.

When you select a template, you can choose either a custom database template or a template with data files. If you select a custom database template (with no data files), you can save the database creation information as a script, which you can later use to create similar databases.
Configure Database Options

This option guides you through the steps of changing your configuration from a dedicated server to a shared server. You can also add database options that have not been previously configured for use with your database.
Delete a Database

This option deletes all the files associated with a selected database.
Manage Templates

This option guides you through the steps of creating and managing database templates. Database templates save you time by saving your database definition to an XML file format on your local hard disk. DBCA provides several pre-defined templates you can use to create your databases. For more information, see Database Templates.

If you select the Manage Templates option, you have three ways to create a template:

  • From an existing template: create a new template using pre-defined template settings. You can add or change any template settings such as parameters, storage, or use custom scripts.

  • From an existing database (structure only): create a new template that has a structure identical to the existing database. This includes tablespaces and storage. You can use an existing database that is either local or remote.

  • From an existing database (structure as well as data): create a template that has both the structure and data of an existing database. You can only use an existing local database.
Instance Management

This option enables you to add new, or delete existing database instances to/from an existing admin-managed Real Application Clusters database.

If there are no admin-managed instances, or only policy-managed databases exist, then this option will be disabled.

For more information, see the Oracle Real Application Clusters Administration and Deployment Guide.

Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.