Creation of Database Manually

create database testdb

user sys identified by testdb

user system identified by testdb

maxinstances 1

maxloghistory 1

maxlogfiles 5

maxlogmembers 5

character set US7ASCII

national character set AL16UTF16

datafile 'E:\oracle\product\10.2.0\oradata\testdb\system01.dbf' size 500M

extent management LOCAL

SYSAUX datafile 'E:\oracle\product\10.2.0\oradata\testdb\sysaux01.dbf' size 500M

DEFAULT TEMPORARY tablespace temp01

tempfile 'E:\oracle\product\10.2.0\oradata\testdb\temp01_01.dbf' size 100M

UNDO tablespace undotbs1

datafile 'E:\oracle\product\10.2.0\oradata\testdb\undotbs01.dbf' size 200M

DEFAULT tablespace users

datafile 'E:\oracle\product\10.2.0\oradata\testdb\users01.dbf' size 100M

LOGFILE group 1

('E:\oracle\product\10.2.0\oradata\testdb\redo01.log') size 100M,

group 2

('E:\oracle\product\10.2.0\oradata\testdb\redo02.log') size 100M;