Manual Database creation Script

CREATE DATABASE ofdb
LOGFILE
GROUP 1 ('/ora1/oracle9/oradata/ofdb/redo01.log') SIZE 10M,
GROUP 2 ('/ora1/oracle9/oradata/ofdb/redo02.log') SIZE 10M
DATAFILE '/ora1/oracle9/oradata/ofdb/system01.dbf' SIZE 100M
AUTOEXTEND ON NEXT 5M MAXSIZE 150M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/ora1/oracle9/oradata/ofdb/temp01.dbf' SIZE 15M
AUTOEXTEND ON NEXT 5M MAXSIZE 30M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/ora1/oracle9/oradata/ofdb/undotbs01.dbf' SIZE 15M
AUTOEXTEND ON NEXT 5M MAXSIZE 60M
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16