Step 7: Issue the CREATE DATABASE Statement (65)
To create the new database, use the CREATE DATABASE statement. The following
statement creates database mynewdb:
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
第七步 : 執行建立資料庫的命令 create database
[@more@]來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-995589/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【OH】Creating a Database with the CREATE DATABASE StatementDatabase
- Understanding the CREATE DATABASE Statement (69)Database
- 【翻譯】Specifying CREATE DATABASE Statement ClausesDatabase
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- Create DatabaseDatabase
- PG create databaseDatabase
- Create database manuallyDatabase
- Step by Step Guide on How to Create Logical Standby [ID 738643.1]GUIIDE
- Oracle BI Answers Direct Database Request issueOracleDatabase
- Step 3: Create the Initialization Parameter File (61)
- Step 8: Create Additional Tablespaces (66)
- 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
- Step 11: Back Up the Database. (69)Database
- Step 5: Create a Server Parameter File (Recommended) (63)Server
- 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
- Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMANGUIIDEORMASM
- Git Step by Step (7)：Git遠端倉庫（續）Git
- Step by Step Guide on converting a database from Windows to AIX-1373780.1GUIIDEDatabaseWindowsAI
- create database 字符集設定Database
- 【UNDO】Step by step to resolve ORA-600 4194 4193 4197 on database crashDatabase
- MM-step to create a new material type/valuation cloass//account category referenceGo
- 4.3.3 使用CREATE DATABASE語句建立CDBDatabase
- alter database ... create datafile的原理及用途Database
- 手動create database 的可用命令Database
- 恢復一則 alter database create datafile '' as ''Database
- Step 2: Establish the Database Administrator Authentication Method (60)Database
- Step By Step Instructions on Migrating Oracle10g Database to Automatic Storage management (ASM)StructOracleDatabaseASM
- Step by step to resolve ORA-600 4194 4193 4197 on database crash [ID 1428786.1]Database