用命令建oracle資料庫執行個體

標籤：建庫

6.建資料庫
CREATE DATABASE fashion
    USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
    LOGFILE GROUP 1 (‘G:\oracle\product\10.2.0\oradata\fashion\redo01.log‘) SIZE 100M,
            GROUP 2 (‘G:\oracle\product\10.2.0\oradata\fashion\redo02.log‘) SIZE 100M,
            GROUP 3 (‘G:\oracle\product\10.2.0\oradata\fashion\redo03.log‘) SIZE 100M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE ‘G:\oracle\product\10.2.0\oradata\fashion\system01.dbf‘ SIZE 500M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE ‘G:\oracle\product\10.2.0\oradata\fashion\sysaux01.dbf‘ SIZE 325M
REUSE 
    DEFAULT TEMPORARY TABLESPACE tempts1    
  TEMPFILE ‘G:\oracle\product\10.2.0\oradata\fashion\temp01.dbf‘  SIZE 20M REUSE
    UNDO TABLESPACE UNDOTBS1--這裡的undotbs1要和初始換參數中的一樣
      DATAFILE ‘G:\oracle\product\10.2.0\oradata\fashion\undotbs01.dbf‘
       SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

 7.建立資料字典
SQL>@?/rdbms/admin/catalog
 SQL>@?/rdbms/admin/catproc
 SQL>conn system/oracle
 SQL>@?/sqlplus/admin/pupbld

本文出自 “青天飛雲” 部落格，謝絕轉載！

用命令建oracle資料庫執行個體