ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 10G手工创建数据库(下)

Oracle 10G手工创建数据库(下)

原创 Linux操作系统 作者:simkyo 时间:2013-06-21 11:49:20 0 删除 编辑

续上:

6、创建数据库:
CREATE DATABASE orcl
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01a.log','/u01/app/oracle/oradata/orcl/redo01b.log') SIZE 300M,
           GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02a.log','/u01/app/oracle/oradata/orcl/redo02b.log') SIZE 300M,
           GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03a.log','/u01/app/oracle/oradata/orcl/redo03b.log') SIZE 300M
   MAXLOGFILES 20
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 500
   MAXINSTANCES 5
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   DEFAULT TABLESPACE users
      DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE temp
      TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf' 
      SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   UNDO TABLESPACE undotbs
      DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; 

7、执行脚本: 
sqlplus / as sysdba
@?/rdbms/admin/catalog;
@?/rdbms/admin/catproc;
@?/rdbms/admin/catblock;
@?/rdbms/admin/catoctk;
@?/rdbms/admin/owminst.plb;
sqlplus system
@?/sqlplus/admin/pupbld.sql;

8、设置默认表空间和默认临时表空间:
alter database default tablespace users;
alter database default temporary tablespace temp;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12961536/viewspace-764489/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-06-20

  • 博文量
    193
  • 访问量
    165517