CREATE TEMPORARY TABLESPACE baistemp TEMPFILE 'c:\bais2\nbaistemp01.dbf' SIZE 100M / CREATE USER newbais IDENTIFIED BY "password" DEFAULT TABLESPACE baisdata TEMPORARY TABLESPACE baistemp PROFILE DEFAULT ACCOUNT UNLOCK / GRANT RESOURCE,CONNECT,DBA,SELECT ANY DICTIONARY,IMP_FULL_DATABASE,EXP_FULL_DATABASE,UNLIMITED TABLESPACE TO newbais / ALTER USER newbais DEFAULT ROLE ALL /
CREATE DATABASE TEST MAXINSTANCES 1 MAXLOGHISTORY 1 MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE 'D:\oracle\oradata\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\oradata\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\oradata\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('D:\oracle\oradata\NCI2009\redo01.log') SIZE 102400K, GROUP 2 ('D:\oracle\oradata\NCI2009\redo02.log') SIZE 102400K, GROUP 3 ('D:\oracle\oradata\NCI2009\redo03.log') SIZE 102400K;
1、dbca创建数据库
2、建表空间
3、创建用户。以下是我创建测试环境的语句。
conn /as sysdbacreate TABLESPACE baisdata DATAFILE
'c:\bais2\baisdata01.dbf' SIZE 1024M
/
create TABLESPACE baisindex DATAFILE
'c:\bais2\baisindex01.dbf' SIZE 500M
/
CREATE TEMPORARY TABLESPACE baistemp TEMPFILE
'c:\bais2\nbaistemp01.dbf' SIZE 100M
/
CREATE USER newbais IDENTIFIED BY "password" DEFAULT TABLESPACE baisdata
TEMPORARY TABLESPACE baistemp PROFILE DEFAULT ACCOUNT UNLOCK
/
GRANT RESOURCE,CONNECT,DBA,SELECT ANY DICTIONARY,IMP_FULL_DATABASE,EXP_FULL_DATABASE,UNLIMITED TABLESPACE TO newbais
/
ALTER USER newbais DEFAULT ROLE ALL
/
dbaca 在创建实例的时候,有一个选项就是修改字符集的.
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\oradata\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\oracle\oradata\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'D:\oracle\oradata\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('D:\oracle\oradata\NCI2009\redo01.log') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\NCI2009\redo02.log') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\NCI2009\redo03.log') SIZE 102400K;