【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了创建数据库.sql提供大家参考,希望对大家有所帮助!
CREATE DATABASE myOraDB
USER SYS IDENTIFIED BY SYSPWD
USER SYSTEM IDENTIFIED BY SYSTEMPWD
CONTROLFILE REUSE
LOGFILE GROUP 1 ('redo01.log ') SIZE 10M,
GROUP 2 ('redo02.log ') SIZE 10M,
MAXLOGFILES 10
MAXLOGMEMBERS 10
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
DATAFILE 'sys01.dbf ' SIZE 100M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'temp01.dbf ' SIZE 10M REUSE;