Sample DB Script

connect sys/oracle as sysdba
startup nomount pfile=/dbs/inittest.ora
create database "test"datafile '/oradata/system01.dbf' size 200M
sysaux datafile '/oradata/sysaux.dbf' size 100M
logfile '/oradata/redo01.log' size 100M,'/oradata/redo01.log' size 100M
character set "WE8ISO8859P1"
national character set "UTF8"
extent management
localundo tablespace undotbs1 datafile '/oradata/undotbs1.dbf' size 100M
default temporary tablespace temp tempfile '/oradata/temp01.dbf' size 100M;
Running Data Dictionary Scripts:
1) catalog.sql (ORACLE_HOME/rdbms/admin)
--- Needed for all normal data dictionary views
2) catproc.sql (ORACLE_HOME/rdbms/admin)
--- Needed to load the initial PL/SQL environment
3) pupbld.sql (ORACLE_HOME/sqlplus/admin)
--- Script to install the SQL*Plus PRODUCT_USER_PROFILE tables