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

DBCA


The DBCA is a Java based tool used to create a database, either from a template or from scratch. This tool is useful to perform ASM configuration and manage RAC services.

The available options are as follows:

Create a Database: This option guides you through the steps of database creation. A database can be created from an existing template, which may or may not include the database files. This option allows you to not only create the database, it also allows you to save the database configuration as a new template. It can save the database creation and configuration as scripts which can be used for future reference, or to manually create the database.

Configure Database Options: This option is used to configure additional options after database creation. This option is disabled if there are currently no databases. The options you can configure here are Data Mining, Text, OLAP, Spatial, Ultra Search, and Label Security. If you have not already configured Enterprise Manager, you can...