Chinaunix首页 | 论坛 | 博客
  • 博客访问: 622555
  • 博文数量: 692
  • 博客积分: 4000
  • 博客等级: 上校
  • 技术积分: 4715
  • 用 户 组: 普通用户
  • 注册时间: 2008-10-17 13:38
文章分类

全部博文(692)

文章存档

2011年(1)

2008年(691)

我的朋友

分类:

2008-10-17 13:44:48

        CREATE DATABASE "eygle"
        MAXINSTANCES 8
        MAXLOGHISTORY 1
        MAXLOGFILES 16
        MAXLOGMEMBERS 3
        MAXDATAFILES 100
        DATAFILE '/opt/oracle/oradata/eygle/system01.dbf'
        SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
        EXTENT MANAGEMENT LOCAL
        SYSAUX DATAFILE '/opt/oracle/oradata/eygle/sysaux01.dbf'
        SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED--SYSAUX表空间的创建
        DEFAULT TEMPORARY TABLESPACE TEMP
        TEMPFILE '/opt/oracle/oradata/eygle/temp01.dbf' SIZE 20M REUSE
        AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
        UNDO TABLESPACE "UNDOTBS1" DATAFILE '/opt/oracle/oradata/eygle/undotbs01.dbf'
        SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
        CHARACTER SET ZHS16GBK
        NATIONAL CHARACTER SET AL16UTF16
        LOGFILE GROUP 1 ('/opt/oracle/oradata/eygle/redo01.log') SIZE 10240K,
        GROUP 2 ('/opt/oracle/oradata/eygle/redo02.log') SIZE 10240K,
        GROUP 3 ('/opt/oracle/oradata/eygle/redo03.log') SIZE 10240K
        USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";


--------------------next---------------------

阅读(243) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~