--创建数据库;
create database hongye
user sys identified by hongye50
user system identified by hongye50
controlfile reuse
maxdatafiles 300
maxinstances 8
maxlogfiles 32
character set "UTF8"
national character set AL16UTF16
archivelog
datafile 'D:\app\HongRihua\oradata\hongye\system01.dbf' size 300M
default temporary tablespace temp
tempfile 'D:\app\HongRihua\oradata\hongye\tempts01.dbf' size 100M
undo tablespace "UNDOTBS1"
datafile 'D:\app\HongRihua\oradata\hongye\undotbs01.dbf' size 200M
LOGFILE
group 1 ('D:\app\HongRihua\oradata\hongye\control01.ctl') size 100M,
group 2 ('D:\app\HongRihua\oradata\hongye\control01.ct2') size 100M,
group 3 ('D:\app\HongRihua\oradata\hongye\control01.ct3') size 100M
;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24465008/viewspace-692326/
,如需转载,请注明出处,否则将追究法律责任。