Understanding the CREATE DATABASE Statement (69)
When you execute a CREATE DATABASE statement, Oracle Database performs (at least)
a number of operations. The actual operations performed depend on the clauses that
you specify in the CREATE DATABASE statement and the initialization parameters that
you have set. Oracle Database performs at least these operations:
■ Creates the datafiles for the database
■ Creates the control files for the database
■ Creates the redo log files for the database and establishes the ARCHIVELOG mode.
■ Creates the SYSTEM tablespace
■ Creates the SYSAUX tablespace
■ Creates the data dictionary
■ Sets the character set that stores data in the database
■ Sets the database time zone
■ Mounts and opens the database for use[@more@]
a number of operations. The actual operations performed depend on the clauses that
you specify in the CREATE DATABASE statement and the initialization parameters that
you have set. Oracle Database performs at least these operations:
■ Creates the datafiles for the database
■ Creates the control files for the database
■ Creates the redo log files for the database and establishes the ARCHIVELOG mode.
■ Creates the SYSTEM tablespace
■ Creates the SYSAUX tablespace
■ Creates the data dictionary
■ Sets the character set that stores data in the database
■ Sets the database time zone
■ Mounts and opens the database for use[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995630/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【OH】Creating a Database with the CREATE DATABASE StatementDatabase
- Step 7: Issue the CREATE DATABASE Statement (65)Database
- 【翻譯】Specifying CREATE DATABASE Statement ClausesDatabase
- Create DatabaseDatabase
- PG create databaseDatabase
- Create database manuallyDatabase
- Step 11: Back Up the Database. (69)Database
- prepare statement cache size influence databaseDatabase
- alter database create datafileDatabase
- CREATE DATABASE LINKDatabase
- alter database create datafile '' as ''Database
- create table of mysql databaseMySqlDatabase
- The method of create a replicate of the database .Database
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- create a database stepsDatabase
- Tasks of a Database Administrator : Create and Open the Database (10)Database
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- 12CR2 using create database command for create non-CDB rac databaseDatabase
- db2 create database 命令DB2Database
- create database 字符集設定Database
- 第5章 閃回資料庫Understanding the Flashback Database資料庫Database
- 4.3.3 使用CREATE DATABASE語句建立CDBDatabase
- alter database ... create datafile的原理及用途Database
- 手動create database 的可用命令Database
- 恢復一則 alter database create datafile '' as ''Database
- 2.4.1 使用 CREATE DATABASE 子句建立資料庫Database資料庫
- create database link中的identified by valuesDatabaseIDE
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- 2.4 使用 CREATE DATABASE 語句建立資料庫Database資料庫
- 【PDB】Oracle 建立pdb說明(create pluggable database)OracleDatabase
- 4、MySQL建立資料庫(CREATE DATABASE語句)MySql資料庫Database
- How to Create Oracle Database QoS Management Administrator AccountsOracleDatabase
- How to create and relocate an 11gr2 RAC DATABASE SERVICEDatabase
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- 4.3.4 使用CREATE DATABASE語句建立一個CDB:示例Database
- ORA-01031 CREATE TRIGGER ON DATABASEDatabase
- oracle create a new database using backup controlfile to traceOracleDatabase
- Statement