手工创建9i数据,复制了官方模版,修改后,如下:
SQL> CREATE DATABASE tan1
2 USER SYS IDENTIFIED BY pz6r58
3 USER SYSTEM IDENTIFIED BY y1tz5p
4 LOGFILE GROUP 1 ('/apps/oracle/oradata/tan1/redo01.log') SIZE 100M,
5 GROUP 2 ('/apps/oracle/oradata/tan1/redo02.log') SIZE 100M,
6 GROUP 3 ('/apps/oracle/oradata/tan1/redo03.log') SIZE 100M
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 MAXINSTANCES 1
12 CHARACTER SET AL32UTF8
13 NATIONAL CHARACTER SET AL16UTF16
14 DATAFILE '/apps/oracle/oradata/tan1/system01.dbf' SIZE 325M REUSE
15 EXTENT MANAGEMENT LOCAL
16 DEFAULT TEMPORARY TABLESPACE tempts1
17 DATAFILE '/apps/oracle/oradata/tan1/temp01.dbf'
18 SIZE 20M REUSE
19 UNDO TABLESPACE UN