spool crdb01.log
CREATE DATABASE david
USER SYS IDENTIFIED BY david
USER SYSTEM IDENTIFIED BY david
LOGFILE GROUP 1 ('/export/home/oracle/oradata/david/redo01.log') SIZE 100M,
GROUP 2 ('/export/home/oracle/oradata/david/redo02.log') SIZE 100M,
GROUP 3 ('/export/home/oracle/oradata/david/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/export/home/oracle/oradata/david/system01.dbf' SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/export/home/oracle/oradata/david/sysaux01.dbf' SIZE 500M REUSE
DEFAULT TABLESPACE tbs_1
DATAFILE '/export/home/oracle/oradata/david/tbs01.dbf'
SIZE 200M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/export/home/oracle/oradata/david/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE '/export/home/oracle/oradata/david/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
spool off
创建数据库脚本
最新推荐文章于 2024-07-16 08:58:32 发布