6. Build a Database
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--The UNDOTBS1 here will be the same as in the initial change parameters.
DataFile ' G:\oracle\product\10.2.0\oradata\fashion\undotbs01.dbf '
SIZE 200M Reuse autoextend on MAXSIZE UNLIMITED;
7. Create a data dictionary
Sql>@?/rdbms/admin/catalog
Sql>@?/rdbms/admin/catproc
Sql>conn system/oracle
Sql>@?/sqlplus/admin/pupbld
This article from the "Sky Fei" blog, declined to reprint!
To build an Oracle DB instance with commands