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

2014-11-24 17:21:39 · 作者: · 浏览: 1
TER DATABASE DEFAULT TABLESPACE SYSTEM


processing /rdbms/admin/dfmap.bsq


processing /rdbms/admin/denv.bsq


processing /rdbms/admin/drac.bsq


processing /rdbms/admin/dsec.bsq


processing /rdbms/admin/doptim.bsq


processing /rdbms/admin/dobj.bsq


processing /rdbms/admin/djava.bsq


processing /rdbms/admin/dpart.bsq


Wed May 21 11:01:34 2014


processing /rdbms/admin/drep.bsq


processing /rdbms/admin/daw.bsq


processing /rdbms/admin/dsummgt.bsq


processing /rdbms/admin/dtools.bsq


processing /rdbms/admin/dexttab.bsq


processing /rdbms/admin/ddm.bsq


processing /rdbms/admin/dlmnr.bsq


processing /rdbms/admin/ddst.bsq


Wed May 21 11:01:43 2014


SMON: enabling tx recovery


Starting background process SMCO


Wed May 21 11:01:44 2014


SMCO started with pid=17, OS id=2816


Wed May 21 11:01:50 2014


replication_dependency_tracking turned off (no async multimaster replication found)


Starting background process QMNC


Wed May 21 11:01:50 2014


QMNC started with pid=20, OS id=2826


Completed: CREATE DATABASE test1


USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE


GROUP 1 ('/u01/app/oracle/oradata/test1/redo01a.log') SIZE 50M ,


GROUP 2 ('/u01/app/oracle/oradata/test1/redo02a.log') SIZE 50M


MAXLOGFILES 10


MAXLOGMEMBERS 5


MAXLOGHISTORY 1


MAXDATAFILES 200


CHARACTER SET zhs16gbk


DATAFILE '/u01/app/oracle/oradata/test1/system01.dbf' SIZE 325M REUSE


SYSAUX DATAFILE '/u01/app/oracle/oradata/test1/sysaux01.dbf' SIZE 325M REUSE


DEFAULT TEMPORARY TABLESPACE tempts1


TEMPFILE '/u01/app/oracle/oradata/test1/temp01.dbf'


SIZE 100M REUSE


UNDO TABLESPACE undotbs1


DATAFILE '/u01/app/oracle/oradata/test1/undotbs01.dbf'


SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED