手動建立資料庫（windows)

1.先建立口令檔案

C:\Documents and Settings\Administrator>orapwd file=d:/oracle/product/10.2.0/db_

1/database/orapwdtest.ora password=admin entries=10

2.準備引數檔案

從另一個資料庫複製一個引數檔案進行修改

3.啟動例項

startup nomount pfile='D:\oracle\product\10.2.0\db_1\database\inittest.ora'

4.建立資料庫

CREATE DATABASE test

LOGFILE

GROUP 1 ('D:\oracle\product\10.2.0\oradata\test\redo01.log') SIZE 100M,

GROUP 2 ('D:\oracle\product\10.2.0\oradata\test\redo02.log') SIZE 100M,

GROUP 3 ('D:\oracle\product\10.2.0\oradata\test\redo03.log') SIZE 100M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

DATAFILE 'D:\oracle\product\10.2.0\oradata\test\system01.dbf' SIZE 325M

extent management local

sysaux datafile 'D:\oracle\product\10.2.0\oradata\test\sysaux01.dbf' SIZE 325M

undo tablespace undotbs1 DATAFILE

'D:\oracle\product\10.2.0\oradata\test\undotbs01.dbf' SIZE 200M

default temporary tablespace temp tempfile

'D:\oracle\product\10.2.0\oradata\test\temp01.dbf' SIZE 325M

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

手動建立資料庫（windows)10G

相關文章