oracle 数据库命令窗口,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