O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image

FIGURE 4-2. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required