CONTROLFILE_REUSE: Indicates that you want to reuse an existing set of control files by overwriting them. I rarely use this option. It's usually just as easy to recreate them from scratch.
LOGFILE: Introduces the LOGFILE clause, which lets you specify an initial set of redo logs for your database.
GROUP group_no: Logfiles are organized into groups. Each group has a number to identify it. The same information is written to each member of a group.
'log_file_name': The full path and filename of a log file.
[SIZE integer[K|M]]: An optional clause that allows you to specify the size of a log file or a datafile. You should always use this. Do not rely on default file sizes. You may specify the size in bytes, kilobytes (K), or megabytes (M).
MAXLOGFILES integer: Places an upper limit on the number of redo log groups that may be created for the database. Oracle reserves space for these groups in the control file.
MAXLOGMEMBERS integer: Places an upper limit on the number of members in a redo log group.
MAXLOGHISTORY integer: Used when running Oracle Parallel Server in archivelog mode. This controls the maximum number of archived log filesthat are tracked in the control file.
MAXDATAFILES integer: Controls the initial size of the area within the control file that is used to keep track of datafiles. Whether this is a maximum depends on the value of the DB_FILES initialization parameter.
MAXINSTANCES integer: Used with Parallel Server, and specifies the maximum number of instances that an simultaneously open this database.
ARCHIVELOG: Causes the database to immediately be placed into archive log mode when it is created. I usually prefer not to do this. Instead I turn on archive log mode after all database, schema, and creation tasks have been completed.
NOARCHIVELOG: This is the default setting and causes the database to be created in noarchive log mode.
CHARACTER_SET 'charset': Specifies the character set that the database uses to store data.
NATIONAL_CHARACTER_SET 'charset': Specifies the character set used to store data in NLS columns, such as those defined as NCHAR, NCLOB, and NVARCHAR2.
DATAFILE 'data_file_name': Specifies the name and directory path to use for the system tablespace's datafile.
AUTOEXTEND: Controls whether Oracle is allowed to expand the size of a datafile automatically. You have two choices: ON and OFF.
OFF: Tells Oracle that the datafile may not be automatically extended. You will need to manually extend the file or add more files if you need more space.
ON: Tells Oracle that it can expand the size of the datafile when necessary.
[NEXT integer [K|M]]: If autoextend is on, you can specify the amount of space to be added each time you extend the datafile.
[MAXSIZE {UNLIMITED | integer [K|M]]: If autoextend is on, allows you to place an upper limit on the file size.
