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, Batch mode


The DBCA is a friendly and very intuitive tool. Creating a database or performing any other activity is a straightforward task. However, assuming a massive deployment scenario, creating databases in the DBCA's interactive mode would be an inefficient, time consuming task, not to mention a human error prone task.

The DBCA has considered this scenario, and it can be launched in batch mode using either the command line or a response file.

This example shows how DBCA executes silently with no graphical interface displayed to the user.

dbca -silent -responseFile <response file>

The response file referred to in the previous example must be created by the user, as unlike the Oracle Universal Installer, the DBCA does not have a 'record' mode.

The next example starts DBCA in batch mode, showing the progress bar, if you want to run in character mode only use the previous example, as presenting the progress bar requires a graphical environment, you must have the DISPLAY environment...