第3章創(chuàng)建數(shù)據(jù)庫手工創(chuàng)建數(shù)據(jù)庫完整步驟系統(tǒng)環(huán)境操作系統(tǒng)：Windows數(shù)據(jù)庫9i安裝路徑：D:\Oracle、手工創(chuàng)建相關(guān)目錄D:\Oracle\admin\DB03\cdumpD:\Oracle\oradata\DB03\archive、工創(chuàng)建初始化參數(shù)文件D:\oracle\admin\DB03\pfile\init.ora，容可以copy別實例D:\oracle\admin\DB01\pfile\init.ora件后把其中的全部修改為、在d:\oracle\ora92\database文件下手工創(chuàng)建initDB03.ora文容IFILE='d:\oracle\admin\db03\pfile\init.ora'、ORADIM-NEW-INTPWD-STARTMODE、在運行中輸入設(shè)置系統(tǒng)環(huán)境變量、創(chuàng)建數(shù)據(jù)庫，執(zhí)行本命令，SQL>sqlplus/nologSYS/adminSQL>@Createdb.sql腳內(nèi)容如下：setechostartuppfile="D:\oracle\admin\DB03\pfile\init.ora";CREATEDB03MAXINSTANCES1MAXLOGHISTORY1MAXLOGFILESMAXLOGMEMBERS5MAXDATAFILESDATAFILESIZEREUSEONNEXT10240KUNLIMITEDUNDOTABLESPACE'D:\oracle\oradata\DB03\undotbs01.dbf'REUSEAUTOEXTENDNEXT5120KMAXSIZEUNLIMITEDCHARACTERNATIONALCHARACTERLOGFILESIZE2('D:\oracle\oradata\DB03\redo02.log')SIZE100M,

3('D:\oracle\oradata\DB03\redo03.log')SIZE100M;offexit;、創(chuàng)建數(shù)據(jù)庫數(shù)據(jù)文件，執(zhí)行腳本createfiles.sqlSQL>sqlplus/nologSQL>SYS/adminas腳內(nèi)容如下：setechoCREATETABLESPACE"INDX"LOGGINGDATAFILE'D:\oracle\oradata\DB03\indx01.dbf'SIZEREUSEAUTOEXTENDONNEXT1280KUNLIMITEDEXTENTMANAGEMENTCREATE"TEMP"TEMPFILE'D:\oracle\oradata\DB03\temp01.dbf'SIZE40MREUSEAUTOEXTENDNEXTUNLIMITEDMANAGEMENTLOCAL;ALTERDEFAULT"TEMP";CREATE"TOOLS"LOGGINGSIZEREUSEONNEXTUNLIMITEDMANAGEMENTCREATE"USERS"LOGGINGSIZEREUSEAUTOEXTENDONNEXT1280KUNLIMITEDEXTENTMANAGEMENTexit;、創(chuàng)建數(shù)據(jù)字典，運行腳命令SQL>sqlplus/nologSQL>SYS/adminasSQL>@createdbcatalog.sqlCreatedbcatalog.sql腳內(nèi)容如下：setecho@D:\oracle\ora92\rdbms\admin\catalog.sql;@D:\oracle\ora92\rdbms\admin\catproc.sql;SYSTEM/manageroffexit;、完善數(shù)據(jù),建文，將數(shù)據(jù)庫實例啟動服務(wù)設(shè)置成自動啟動方式。SQL>sqlplus/nologSQL>SYS/adminasSQL>本內(nèi)容如下：setechocreateFROM

setecho;startup(10)過以下查詢命令，檢查實例是否工作正常建表StudentSql>selectfromcreatetableStudent(char(8),varchar2(10)notnull,Stu_ageStu_deptCONSTRAINTpk_snoPRIMARYselect*student;插條記錄student表。SQL>Student李'男'計算機(jī)'intoStudent李'男'計算機(jī)'intoStudent李'男'計算機(jī)'intoStudent李'男'計算機(jī)'intoStudent李'男'計算機(jī)'select*student;將表中號為的生齡改18studentsetstu_age=18stu_no='20026102';select*student;刪選課號學(xué)的績錄SQL>deleteStudentStu_noselect*student;注都