Oraclei数据库的创建.pptVIP

Createdb.sql脚本内容如下： connect SYS/change_on_install as SYSDBA set echo on spool c:\oracle\ora90\assistants\dbca\logs\CreateDB.log startup nomount pfile=“c:\oracle\admin\demo\pfile\init.ora; CREATE DATABASE demo MAXINSTANCES 1 MAXLOGHISTORY 1 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXDATAFILES 100 DATAFILE ‘c:\oracle\oradata\demo\system01.dbf SIZE 32M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED UNDO TABLESPACE UNDOTBS DATAFILE ‘c:\oracle\oradata\demo\undotbs01.dbf SIZE 20M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 (‘c:\