安装完成windows 平台软件以后，如何进行建库呢。手工建库过程如下：
 
 
 
第一步:
 
mkdir E:\oracle\admin\test\bdump
mkdir E:\oracle\admin\test\cdump
mkdir E:\oracle\admin\test\create
mkdir E:\oracle\admin\test\pfile
mkdir E:\oracle\admin\test\udump
mkdir E:\oracle\ora92\database
mkdir E:\oracle\oradata\test
set ORACLE_SID=test
E:\oracle\ora92\bin\oradim.exe -new  -sid TEST -startmode m
E:\oracle\ora92\bin\oradim.exe -edit  -sid TEST -startmode a
E:\oracle\ora92\bin\orapwd.exe file=E:\oracle\ora92\database\PWDtest.ora password=change_on_install
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDB.sql
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDBFiles.sql
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDBCatalog.sql
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\postDBCreation.sql
 
 
 
第二步:
 
运行: E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDB.sql
 
createdb.sql
 
connect SYS/change_on_install as SYSDBA
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\CreateDB.log
startup nomount pfile="E:\oracle\admin\test\scripts\init.ora";
CREATE DATABASE test
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'E:\oracle\oradata\test\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\oracle\oradata\test\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\oracle\oradata\test\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('E:\oracle\oradata\test\redo01.log') SIZE 102400K,
GROUP 2 ('E:\oracle\oradata\test\redo02.log') SIZE 102400K,
GROUP 3 ('E:\oracle\oradata\test\redo03.log') SIZE 102400K;
spool off
exit;
 
 
第三步:
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDBFiles.sql
内容是:
CreateDBFiles.sql
 
 
connect SYS/change_on_install as SYSDBA
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\CreateDBFiles.log
CREATE TABLESPACE "INDX" LOGGING DATAFILE 'E:\oracle\oradata\test\indx01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'E:\oracle\oradata\test\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT  320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
CREATE TABLESPACE "USERS" LOGGING DATAFILE 'E:\oracle\oradata\test\users01.dbf' SIZE 25M REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
spool off
exit;
 
 
第四步:
运行#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\CreateDBCatalog.sql
 
connect SYS/change_on_install as SYSDBA
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\CreateDBCatalog.log
@E:\oracle\ora92\rdbms\admin\catalog.sql;
@E:\oracle\ora92\rdbms\admin\catexp7.sql;
@E:\oracle\ora92\rdbms\admin\catblock.sql;
@E:\oracle\ora92\rdbms\admin\catproc.sql;
@E:\oracle\ora92\rdbms\admin\catoctk.sql;
@E:\oracle\ora92\rdbms\admin\owminst.plb;
connect SYSTEM/manager
@E:\oracle\ora92\sqlplus\admin\pupbld.sql;
connect SYSTEM/manager
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\sqlPlusHelp.log
@E:\oracle\ora92\sqlplus\admin\help\hlpbld.sql helpus.sql;
spool off
spool off
exit;
 
 
第五步:
#E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\test\scripts\postDBCreation.sql
 
 
 
connect SYS/change_on_install as SYSDBA
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\postDBCreation.log
@E:\oracle\ora92\rdbms\admin\utlrp.sql;
shutdown ;
connect SYS/change_on_install as SYSDBA
set echo on
spool E:\oracle\ora92\assistants\dbca\logs\postDBCreation.log
create spfile='E:\oracle\ora92\database\spfiletest.ora' FROM pfile='E:\oracle\admin\test\scripts\init.ora';
startup ;