The DBCA is mostly known as the tool used to create a database. If the DBA performs a default installation with the database creation option, it can be seen how the DBCA creates the started database. This section is a walk-through of the DBCA creating DB screens.
Creating a database can of course, be done using the command line CREATE DATABASE
command, but most DBA's prefer using the DBCA because it is pretty easy and intuitive, and it allows DBA's to easily manage different database options. This section introduces us to the concepts of templates, and this topic will be developed in further detail later in this chapter.
The Database Creation option can create the database internally using the CREATE DATABASE
command with the Custom Database option, or it can create the database an existing template (A) which may or may not include datafiles (B). If datafiles are included then the database is created by a cloning procedure. Optionally, you can click...