oracle命令行创建数据库的示例脚本

set echo on
spool D:\oracle\app\admin\ocp11g\sctripts\cteatedb.log
startup nomount pfile"D:\oracle\app\admin\ocp11g\sctrpts\init.ora";
create database "ocp11g"
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile 'D:\oracle\app\oradata\ocp11g\system01.dbf' size 300m reuse autoextend on next 10240k maxsize unlimited extent management local
sysaux datafile 'D:\oracle\app\oradata\ocp11g\sysaux01.dbf' size 120m reuse autoextend on next 10240k maxsize unlimited 
smallfile default temporary tablespace temp tempfile 'D:\oracle\app\oradata\ocp11g\temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited 
smallfile undo tablespace "undotbs1" datafile 'D:\oracle\app\oradata\ocp11g\undotbs01.dbf' size 200m reuse autoextend on next 5120k maxsize unlimited
character set we8mswin1252
national character set al16utf16
logfile group 1 ('D:\oracle\app\oradata\ocp11g\redo01.log') size 51200k,group 2 ('D:\oracle\app\oradata\ocp11g\redo02.log') size 51200k,group 3 ('D:\oracle\app\oradata\ocp11g\redo03.log') size 51200k
user sys identified by "&&systemPassword"
user system identified by "&&systemPassword";
spool off
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值