oracle命令建数据库,用命令建oracle数据库实例

6.建数据库

CREATE DATABASE fashion

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('G:\oracle\product\10.2.0\oradata\fashion\redo01.log') SIZE 100M,

GROUP 2 ('G:\oracle\product\10.2.0\oradata\fashion\redo02.log') SIZE 100M,

GROUP 3 ('G:\oracle\product\10.2.0\oradata\fashion\redo03.log') SIZE 100M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE 'G:\oracle\product\10.2.0\oradata\fashion\system01.dbf' SIZE 500M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE 'G:\oracle\product\10.2.0\oradata\fashion\sysaux01.dbf' SIZE 325M

REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE 'G:\oracle\product\10.2.0\oradata\fashion\temp01.dbf'  SIZE 20M REUSE

UNDO TABLESPACE UNDOTBS1--这里的undotbs1要和初始换参数中的一样

DATAFILE 'G:\oracle\product\10.2.0\oradata\fashion\undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

7.创建数据字典

SQL>@?/rdbms/admin/catalog

SQL>@?/rdbms/admin/catproc

SQL>conn system/oracle

SQL>@?/sqlplus/admin/pupbld