Oracle A423961 User Manual

☞

☞

☞

SQL Ref.

3 – 17

Using Oracle7 Server for Windows NT

   The CONTROL_FILES parameter in the

INITsid.ORA file must specify the complete path(s) of control
file(s), including drive designators. For example:

CONTROL_FILES =

(D:\MY_ORACLE_HOME\DATABASE\CTL1ABC.ORA)

OR

CONTROL_FILES = (%RDBMS73%\DATABASE\CTL1ABC.ORA)

%RDBMS73%

 is instantiated by Oracle to a directory

with the drive designator stated above. If a drive letter(s) is not
provided, Oracle will not start properly.

   See Initialization File Parameters in this Guide for

important additional information on modifying Windows
NT–specific initialization parameters. See also Oracle7 Server
Administrator’s Guide.

8.

(Optional) Use a text editor to create a SQL script containing the
CREATE DATABASE statement.

A SQL script is a file containing SQL commands just as you would
type them in Server Manager. Using a SQL script makes it easier to
edit and verify the SQL statement required for creating a new
database.

Use the following syntax for the CREATE DATABASE statement:

CREATE DATABASE database_name

[CONTROLFILE REUSE]

[LOGFILE filespec [,filespec] ...]

[MAXLOGFILES integer]

[MAXLOGMEMBERS integer]

[DATAFILE filespec [,filespec] ...]

[MAXDATAFILES integer]

[ARCHIVELOG | NOARCHIVELOG]

[EXCLUSIVE]

[CHARACTER SET name]

   If you assigned a value to the DB_NAME

initialization parameter in the 

INIT

sid.ORA

 file, be sure you

use the same value for the database_name parameter in the
CREATE DATABASE statement.

The CREATE DATABASE parameters are described in Chapter 3.

   The remaining parameters in the

CREATE DATABASE statement are described in Oracle7 Server
SQL Reference.