Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Database creation


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.

Database templates

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...