Oracle A423961 - Manual (Page 75)

☞
☞
☞
SQL Ref.
3 – 17 Using Oracle7 Server for Windows NT
Attention: 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)
Warning: %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.
Attention: 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]
Attention: 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.
Additional Information: The remaining parameters in the
CREATE DATABASE statement are described in Oracle7 Server
SQL Reference.