Oracle 10g AND Oracle 11g手工建库案例之--Oracle 10g(二)

2014-11-24 17:21:38 · 作者: · 浏览: 2
ENT AUTO online


Completed: create tablespace SYSAUX datafile '$ORACLE_BASE/oradata/test/sysaux01.dbf' size 100m


EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online


Sat Aug 20 00:26:54 2011


CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '$ORACLE_BASE/oradata/test/temp01.dbf' size 100m


Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '$ORACLE_BASE/oradata/test/temp01.dbf' size 100m


Sat Aug 20 00:26:55 2011


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP


Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP


Sat Aug 20 00:26:55 2011


ALTER DATABASE DEFAULT TABLESPACE SYSTEM


Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM


Sat Aug 20 00:27:01 2011


SMON: enabling tx recovery


Sat Aug 20 00:27:02 2011


Threshold validation cannot be done before catproc is loaded.


replication_dependency_tracking turned off (no async multimaster replication found)


Starting background process QMNC


QMNC started with pid=13, OS id=6485


Sat Aug 20 00:27:03 2011


Completed: create database test


user sys identified by **user system identified by *datafile '$ORACLE_BASE/oradata/test/system01.dbf' size 400m


sysaux datafile '$ORACLE_BASE/oradata/test/sysaux01.dbf' size 100m


undo tablespace rtbs datafile '$ORACLE_BASE/oradata/test/rtbs01.dbf' size 100m


default temporary tablespace temp tempfile '$ORACLE_BASE/oradata/test/temp01.dbf' size 100m


logfile


group 1 '$ORACLE_BASE/oradata/test/redo01a.log' size 10m,


group 2 '$ORACLE_BASE/oradata/test/redo02a.log' size 10m,


group 3 '$ORACLE_BASE/oradata/test/redo03a.log' size 10m


character set zhs16gbk