Created
October 25, 2015 10:03
-
-
Save gghatano/9a5a744321abab32371e to your computer and use it in GitHub Desktop.
create database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE orcl | |
USER SYS IDENTIFIED BY oracle_4U | |
USER SYSTEM IDENTIFIED BY oracle_4U | |
LOGFILE GROUP 1 ('log1A', | |
'/disk1/log1B' | |
'/disk2/log1C') SIZE 10M | |
GROUP 2 ('log2B', | |
'/disk1/log2B' | |
'/disk2/log2C') SIZE 10M | |
-- MAXLOGMEMBERS 3 | |
-- MAXLOGGROUPS 2 | |
-- system | |
DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' SIZE 256M | |
AUTOEXTEND ON NEXT 64M | |
MAXSIZE UNLIMITED | |
SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 256M | |
DEFAULT TEMPORARY TABLESPACE temporary | |
TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf' SIZE 256M | |
UNDO TABLESPACE undo | |
DATAFILE '/u01/app/oracle/oradata/orcl/undo01.dbf' SIZE 256M | |
-- 他の表領域とデータファイル | |
ARCHIVELOG | |
CHARACTER SET AL32UTF8 | |
; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment