Create database manually on ORACLE 11g
Hi, I'm trying to create a database manually. So I follow this steps:
1) I connect on sqlplus using the command: sqlplus /nolog
2) SQL>conn / as sysdba
3) SQL>@ create_db.sql
SQL shows the following error:
UNDO TABLESPACE UNDOTBS
*
ERROR at line 17:
ORA-02236: invalid file name
Can anybody tellme what is the problem??
Aditional information:_
SQL scrip "create_db.sql":
CREATE DATABASE PRUEBA
MAXLOGFILES 3
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXLOGHISTORY 0
LOGFILE GROUP 1
('/oradata/prueba/origlog/redo_g1m1.log',
'/oradata/prueba/mirrorlog/redo_g1m2.log') SIZE 10 M,
GROUP 2
('/oradata/prueba/origlog/redo_g2m1.log',
'/oradata/prueba/mirrorlog/redo_g2m2.log') SIZE 10 M,
GROUP 3
('/oradata/prueba/origlog/redo_g3m1.log',
'/oradata/prueba/mirrorlog/redo_g3m2.log') SIZE 10 M,
DATAFILE
'/oradata/prueba/data1/system.dbf' SIZE 300 M,
UNDO TABLESPACE UNDOTBS
DATAFILE '/oradata/prueba/data1/undo_tbs.dbf' SIZE 500 M,
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/oradata/prueba/data1/temp01.dbf' SIZE 500 M,
CHARACTER SET WE8ISO8859P1;
I'm working on a HP-UX 11.1 system
Thanks