创建数据库脚本

来源：互联网发布：绿色物业软件编辑：程序博客网时间：2024/04/30 18:18

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