本文介绍了一个具体的Oracle数据库创建过程，包括定义数据文件、重做日志文件、表空间及各种参数配置等。此数据库采用US7ASCII字符集，并指定了多个重做日志文件组、数据文件以及临时表空间。
CREATE DATABASE mynewdb
<wbr><wbr> USER SYS IDENTIFIED BY pz6r58<br><wbr><wbr> USER SYSTEM IDENTIFIED BY y1tz5p<br><wbr><wbr> LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M<br><wbr><wbr> MAXLOGFILES 5<br><wbr><wbr> MAXLOGMEMBERS 5<br><wbr><wbr> MAXLOGHISTORY 1<br><wbr><wbr> MAXDATAFILES 100<br><wbr><wbr> MAXINSTANCES 1<br><wbr><wbr> CHARACTER SET US7ASCII<br><wbr><wbr> NATIONAL CHARACTER SET AL16UTF16<br><wbr><wbr> DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE<br><wbr><wbr> EXTENT MANAGEMENT LOCAL<br><wbr><wbr> SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE<br><wbr><wbr> DEFAULT TABLESPACE tbs_1<br><wbr><wbr> DEFAULT TEMPORARY TABLESPACE tempts1<br><wbr><wbr><wbr><wbr><wbr> TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf'<br><wbr><wbr><wbr><wbr><wbr> SIZE 20M REUSE<br><wbr><wbr> UNDO TABLESPACE undotbs<br><wbr><wbr><wbr><wbr><wbr> DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'<br><wbr><wbr><wbr><wbr><wbr> SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; </wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr> USER SYS IDENTIFIED BY pz6r58<br><wbr><wbr> USER SYSTEM IDENTIFIED BY y1tz5p<br><wbr><wbr> LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M<br><wbr><wbr> MAXLOGFILES 5<br><wbr><wbr> MAXLOGMEMBERS 5<br><wbr><wbr> MAXLOGHISTORY 1<br><wbr><wbr> MAXDATAFILES 100<br><wbr><wbr> MAXINSTANCES 1<br><wbr><wbr> CHARACTER SET US7ASCII<br><wbr><wbr> NATIONAL CHARACTER SET AL16UTF16<br><wbr><wbr> DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE<br><wbr><wbr> EXTENT MANAGEMENT LOCAL<br><wbr><wbr> SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE<br><wbr><wbr> DEFAULT TABLESPACE tbs_1<br><wbr><wbr> DEFAULT TEMPORARY TABLESPACE tempts1<br><wbr><wbr><wbr><wbr><wbr> TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf'<br><wbr><wbr><wbr><wbr><wbr> SIZE 20M REUSE<br><wbr><wbr> UNDO TABLESPACE undotbs<br><wbr><wbr><wbr><wbr><wbr> DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'<br><wbr><wbr><wbr><wbr><wbr> SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; </wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
扫一扫
5413
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
