Skip to content

Instantly share code, notes, and snippets.

@gghatano
Created October 25, 2015 10:03
Show Gist options
  • Save gghatano/9a5a744321abab32371e to your computer and use it in GitHub Desktop.
Save gghatano/9a5a744321abab32371e to your computer and use it in GitHub Desktop.
create database
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