TOAD® Handbook

Creating a New Database

Creating a new database sounds like a simple task. But as with any other complex endeavor, the foundation you lay at the start will determine your success. Many DBAs have scripts they’ve written over the years for creating databases that they can “hack upon” for current needs. Other DBAs prefer to use Oracle’s Database Configuration Assistant (available with later versions of the database). But both these approaches suffer the same drawback; the DBA must be intimate with every single Oracle feature for the target database version and must explicitly define all the necessary information in Oracle terms. The problem is that you may well be a developer whose responsibilities include certain DBA functions. In that case, you ...