oracle命令列建立資料庫的樣本指令碼

來源:互聯網
上載者:User
set echo onspool D:\oracle\app\admin\ocp11g\sctripts\cteatedb.logstartup nomount pfile"D:\oracle\app\admin\ocp11g\sctrpts\init.ora";create database "ocp11g"maxinstances 8maxloghistory 1maxlogfiles 16maxlogmembers 3maxdatafiles 100datafile 'D:\oracle\app\oradata\ocp11g\system01.dbf' size 300m reuse autoextend on next 10240k maxsize unlimited extent management localsysaux 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 unlimitedcharacter set we8mswin1252national character set al16utf16logfile 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 51200kuser sys identified by "&&systemPassword"user system identified by "&&systemPassword";spool off

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.