How to Create a Database in Oracle 8I
- 1). Backup any existing database files including the parameter files, datafiles, redo log files and control files.
- 2). Copy the parameter file that is provided on the Oracle distribution media. The copy should be given a unique name.
- 3). Open the new parameter files and change the values of "DB_NAME," "DB_DOMAIN," "CONTROL_FILES," "DB_BLOCK_SIZE," "DB_BLOCK_BUFFERS," "PROCESSES," "ROLLBACK_SEGMENTS," "LICENSE_MAX_SESSIONS," "LICENSE_SESSION_WARNING" and "LICENSE_MAX_USERS."
- 4). Check that the Oracle instance identifier matches the value of "DB_NAME" in the parameters file.
- 5). Open a terminal window, if you are using a Unix or Linux operating system, or the command prompt, if you are using the Windows operating system.
- 6). Type the command "SQLPLUS /nolog" to connect to the Oracle database. You will be presented with the "SQL>" command prompt where you will type the rest of the commands.
- 7). Type the command "STARTUP NOMOUNT;" to start an instance without mounting a database.
- 8). Type the command "CREATE DATABASE example DATAFILE 'example_system' SIZE 15M LOGFILE GROUP 1 ('example_log1a', 'example_log1b') SIZE 500K, GROUP 2 ('example_log2a', 'example_log2b') SIZE 500K;" to create a database name "example."
- 9). Type the command "QUIT" to exit the database.
Source...