有create database的create database test controlfile reuse datafile 'd:\data\system1.dbf' size 100m autoextend on next 100m maxsize unlimited sysaux datafile 'd:\data\sysaux1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited default temporary tablespace temp1 tempfile 'd:\data\temp1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited undo tablespace UNDOTBS1 datafile 'd:\data\undo1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited default tablespace user1 datafile 'd:\data\user1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited extent management local autoallocate logfile group 1 'd:\data\redo1.log' size 100m reuse, group 2 'd:\data\redo2.log' size 100m reuse, group 3 'd:\data\redo3.log' size 100m reuse character set al32utf8 user sys identified by oracle user system identified by oracle用dbca 创建也可以
controlfile reuse
datafile 'd:\data\system1.dbf' size 100m autoextend on next 100m maxsize unlimited
sysaux datafile 'd:\data\sysaux1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
default temporary tablespace temp1
tempfile 'd:\data\temp1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
undo tablespace UNDOTBS1
datafile 'd:\data\undo1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
default tablespace user1
datafile 'd:\data\user1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
extent management local autoallocate
logfile group 1 'd:\data\redo1.log' size 100m reuse,
group 2 'd:\data\redo2.log' size 100m reuse,
group 3 'd:\data\redo3.log' size 100m reuse
character set al32utf8
user sys identified by oracle
user system identified by oracle用dbca 创建也可以
包括以 SYSDBA 身份启动实例,通过 CREATE DATABASE 语句创建数据库(控制文件、数据文件和日志文件),执行 $ORACLE_HOME/rdbms/admin 目录下的相关脚本,创建数据字典和自带的程序包,以及创建其他的数据库功能(如 OLAP、spatial 等)。