【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供2.3.9.sql参考,解决您在2.3.9.sql学习中工作中的难题,参考学习。
conn sys/password as sysdba
startup nomount;
CREATE DATABASE orcl
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_pass
word LOGFILE GROUP 1 ('$ORACLE_HOME/$ORACLE_SID/redo01.log') SIZE 100M,
GROUP 2 ('$ORACLE_HOME/$ORACLE_SID/redo02.log') SIZE 100M,
GROUP 3 ('$ORACLE_HOME/$ORACLE_SID/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '$ORACLE_HOME/$ORACLE_SID/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '$ORACLE_HOME/$ORACLE_SID/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '$ORACLE_HOME/$ORACLE_SID/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '$ORACLE_HOME/$ORACLE_SID/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '$ORACLE_HOME/$ORACLE_SID/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE orcl
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
DEFAULT TABLESPACE users;