Overview of Database Creation Tasks on Windows Using Command-Line Tools
Learn how to create a new database manually. As part of its database software files, Oracle Database provides a sample initialization parameter file, which can you can edit to suit your needs.
You can choose to create database creation scripts using Oracle Database Configuration Assistant.
The following are the types of Database creation tasks:
-
Copy an existing database and delete the old database.
-
Copy an existing database and keep the old database.
-
Create a new database when no database exists on your system.
Manual Database Creation Tasks
Use Manual Database Creation Tasks to understand the manual tasks involved in creating a new database for each of these database creation categories. Each step is explained in detail in the following subsections.
Table 4-1 Manual Database Creation Tasks
| Task | Copy existing database and delete old database | Copy existing database and keep old database | Create new database when no database exists on system |
|---|---|---|---|
| About Exporting an Existing Database |
Yes |
Note 1 |
Not applicable |
| Deleting Database Files |
Yes |
No |
Not applicable |
| Modifying the Initialization Parameter File |
Yes |
Yes |
Yes |
| Starting an Oracle Database Instance |
Yes |
Yes |
Yes |
| About Creating and Starting an Oracle Database Service |
No |
Yes |
Yes |
| Adding the CREATE DATABASE Statement in a Script |
Yes |
Yes |
Yes |
| Running the CREATE DATABASE Script |
Yes |
Yes |
Yes |
| About Importing a Database |
Yes |
Note 2 |
Not applicable |
| Updating ORACLE_SID in the Registry |
No |
Only if you change the default |
Yes |
| Backing Up the New Database |
Yes |
Yes |
Yes |
Note:
If you copy data from an existing database to the new database, select Yes; otherwise, No. Also, if you import tables and other objects from the existing database, select Yes; otherwise, No.An example in the following sections demonstrates how to create a database. In this example, the existing database is the starter database with a SID of orcl located in directory C:\app\username\oradata\orcl. Copy orcl to a new database with a database name and SID of prod located in the directory C:\app\username\oradata\prod. Then, delete the starter database orcl.
- About Exporting an Existing Database
You are required to export an existing database only if you intend to copy its contents to a new database. - Deleting Database Files
Deleting database files is required only when you copy an existing database to a new database to replace the old database. - Modifying the Initialization Parameter File
Describes how to modify the initialization parameter file. - About Creating and Starting an Oracle Database Service
Learn how to create and start an Oracle Database service. - Starting an Oracle Database Instance
Learn how to start an instance without mounting a database. - Adding the CREATE DATABASE Statement in a Script
TheCREATE DATABASEstatement is a SQL statement that creates the database. - Running the CREATE DATABASE Script
Use this procedure to run the CREATE DATABASE script. - About Importing a Database
Learn how to use Data Pump Import or Import. - Updating ORACLE_SID in the Registry
If this is the first database on your computer or if you intend to make the new database the default database, then you must make a change in the registry. - Creating the ORACLE_SID Parameter
If you do not yet have the parameterORACLE_SID, because this is the first database on your system, then you must create it. - Backing Up the New Database
Use this procedure to prevent data loss.
Parent topic: Postinstallation Database Creation on Windows