Creating Databases
Oracle provides the Database Configuration Assistant (DBCA) to help you create new databases. Other assistants are available for configuring upgrades (DBUA) and Oracle Enterprise Manager (EMCA). You can also use database scripts and templates to re-create databases with the same configuration. We’ll start by walking through the DBCA.
Using the DBCA
The DBCA will create the instance parts, which are the processes and the datafiles for the database. It will set up the memory structures.
Launch the DBCA from the ORACLE_HOME\bin directory. Figure 4-2 shows step 1 of the assistant, where you select to create a database.
FIGURE 4-2. ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
