RelationalDBDesignRelationalDBDesign


Create Database   «Prev 

CREATE DATABASE command syntax

Create DATABASE
  1. 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.
  2. LOGFILE: Introduces the LOGFILE clause, which lets you specify an initial set of redo logs for your database.
  3. 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.
  4. 'log_file_name': The full path and filename of a log file.
  5. [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).
  6. 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.
  7. MAXLOGMEMBERS integer: Places an upper limit on the number of members in a redo log group.
  8. 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.
  9. 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.
  10. MAXINSTANCES integer: Used with Parallel Server, and specifies the maximum number of instances that an simultaneously open this database.
  11. 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.
  12. NOARCHIVELOG: This is the default setting and causes the database to be created in noarchive log mode.
  13. CHARACTER_SET 'charset': Specifies the character set that the database uses to store data.
  14. NATIONAL_CHARACTER_SET 'charset': Specifies the character set used to store data in NLS columns, such as those defined as NCHAR, NCLOB, and NVARCHAR2.
  15. DATAFILE 'data_file_name': Specifies the name and directory path to use for the system tablespace's datafile.
  16. AUTOEXTEND: Controls whether Oracle is allowed to expand the size of a datafile automatically. You have two choices: ON and OFF.
  17. 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.
  18. ON: Tells Oracle that it can expand the size of the datafile when necessary.
  19. [NEXT integer [K|M]]: If autoextend is on, you can specify the amount of space to be added each time you extend the datafile.
  20. [MAXSIZE {UNLIMITED | integer [K|M]]: If autoextend is on, allows you to place an upper limit on the file size.