CREATE DATABASE college
datafile '/disk2/oradata/college/system.dbf' size 150m autoextend on

sysaux datafile '/disk2/oradata/college/sysaux.dbf' size 100m autoextend on

default temporary tablespace temp tempfile '/disk2/oradata/college/temp.dbf' size 10m

default tablespace userdata datafile '/disk2/oradata/college/userdata.dbf' size 10m

undo tablespace undotbs datafile '/disk2/oradata/college/undotbs.dbf' size 10m

logfile
group 1 ('/disk2/oradata/college/redolog1a.log','/disk2/oradata/college/redolog1b.log') size 5000k,
group 2 ('/disk2/oradata/college/redolog2a.log','/disk2/oradata/college/redolog2b.log') size 5000k

controlfile reuse;

[oracle@localhost dbs]$ export ORACLE_SID=college
[oracle@localhost dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 14 09:21:45 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  100663296 bytes
Fixed Size                  1217884 bytes
Variable Size              88083108 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
SQL> @$ORACLE_HOME/notes/createdb.sql
SP2-0734: unknown command beginning "sysaux dat..." - rest of line ignored.
SP2-0734: unknown command beginning "default te..." - rest of line ignored.
SP2-0734: unknown command beginning "default ta..." - rest of line ignored.
SP2-0734: unknown command beginning "undo table..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0042: unknown command "logfile" - rest of line ignored.
SP2-0734: unknown command beginning "group 1 ('..." - rest of line ignored.
SP2-0734: unknown command beginning "group 2 ('..." - rest of line ignored.
SP2-0734: unknown command beginning "controlfil..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.

Set SQLBLANKLINES ON