手工创建Oracle数据库

Total System Global Area  167772160 bytes
Fixed Size                  1247924 bytes
Variable Size             104858956 bytes
Database Buffers           54525952 bytes
Redo Buffers                7139328 bytes

4.根据刚刚修改的pfile文件创建spfile文件
SQL>create spfile from pfile;

File created.

5.执行creata database脚本
SQL>@F:\oracle\product\admin\abc\create\createdb.sql

Database created.

#createdb.sql脚本的具体内容如下（可以看出内容很简洁，所有的数据文件的具体信息都不用指定）：
create database abc
user sys identified by oracle
user system identified by oracle
default temporary tablespace temp
undo tablespace undotbs1
character set utf8
national character set al16utf16;

6.查看数据库的各个文件的位置和名称
6.1在线日志文件
SQL>select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------------------------------------
         1 F:\ORACLE\PRODUCT\ORADATA\ABC\ONLINELOG\O1_MF_1_40PN2T5C_.LOG
         2 F:\ORACLE\PRODUCT\ORADATA\ABC\ONLINELOG\O1_MF_2_40PN312X_.LOG

6.2数据文件
SQL>select tablespace_name,file_name from dba_data_files;

TABLESPACE FILE_NAME
---------- -------------------------------------------------------------------------------
SYSTEM     F:\ORACLE\PRODUCT\ORADATA\ABC\DATAFILE\O1_MF_SYSTEM_40PN388S_.DBF
UNDOTBS1   F:\ORACLE\PRODUCT\ORADATA\ABC\DATAFILE\O1_MF_UNDOTBS1_40PN3OLK_.DBF
SYSAUX     F:\ORACLE\PRODUCT\ORADATA\ABC\DATAFILE\O1_MF_SYSAUX_40PN3Q00_.DBF

6.3临时文件
SQL>select tablespace_name,file_name from dba_temp_files;

TABLESPACE FILE_NAME
---------- ---------------------------------------------------------------------
TEMP       F:\ORACLE\PRODUCT\ORADATA\ABC\DATAFILE\O1_MF_TEMP_40PN3YJ3_.TMP

到此数据库abc创建完毕，可以正常使用了

三、附录：
create database的全部语法:

CREATE DATABASE database
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
CONTROLFILE REUSE
MAXDATAFILES integer
MAXINSTANCES integer
MAXLOGFILES integer
MAXLOGMEMBERS integer
MAXLOGHISTORY integer
CHARACTER SET charset
NATIONAL CHARACTER SET charset
SET DEFAULT BIGFILE(SMALLFILE) TABLESPACE
LOGFILE GROUP integer file_specification
ARCHIVELOG(NOARCHIVELOG)
FORCE LOGGING
DATAFILE file_specification
SYSAUX DATAFILE file_specification
DEFAULT TABLESPACE tablespace DATAFILE datafile_tempfile_spec extent_management_clause
BIGFILE(SMALLFILE) DEFAULT TEMPORARY TABLESPACE tablespace TEMPFILE file_specifi