Create Database Manually

Hello all,

This sql script help to  create databse manually.

CREATE DATABASE test


USER SYS IDENTIFIED BY sys

USER SYSTEM IDENTIFIED BY system

LOGFILE

GROUP 1 ('/disk2/oradata9i/oracle/test/redo01.log') SIZE 100M,

GROUP 2 ('/disk2/oradata9i/oracle/test/redo02.log') SIZE 100M,

GROUP 3 ('/disk2/oradata9i/oracle/test/redo03.log') SIZE 100M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/disk2/oradata9i/oracle/test/system01.dbf' SIZE 320M REUSE

EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/disk2/oradata9i/oracle/test/temp01.dbf'SIZE 200M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/disk2/oradata9i/oracle/test/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
 
 
 
For Remaing process chc  this link.
http://www.dba-oracle.com/oracle_create_database.htm