What are the Advantages of Using DBCA

These are a few of the advantages of using DBCA:

You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide varying levels of detail. You can provide a minimum of input and allow Oracle to make decisions for you, eliminating the need to spend time deciding how best to set parameters or structure the database. Optionally, it allows you to be very specific about parameter settings and file allocations.

It builds efficient and effective databases that take advantage of Oracle's new features.

It uses Optimal Flexible Architecture (OFA), whereby database files and administrative files, including initialization files, follow standard naming and placement practices

Interview Candidate
Jul 19th, 2005
1
3939

Database Administration

Answer

Showing Answers 1 - 1 of 1 Answers

oradba

Apr 6th, 2006

The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database.
Many of the database creation tasks you would normally perform manually are performed automatically after you select your database options with the Database Configuration Assistant. With the Database Configuration Assistant you can select from a list of pre-defined database templates, or you can use an existing database as a sample for creating a template. If you are using Real Application Clusters, you can use the Database Configuration Assistant to manage the instances and services associated with your Real Application Cluster environment.
Note: Oracle recommends that you close other applications when running Database Configuration Assistant.