ORA-02236 invalid file name during database creation
474257Dec 28 2005 — edited Dec 28 2005Hi,
I tried to create a database manually. Here is my SQL codes :
CREATE DATABASE dbtest
USER SYS IDENTIFIED BY password
USER SYSTEM IDENTIFIED BY password
LOGFILE GROUP 1 ('/opt/oracle/oradata/redo01.log') SIZE 10M,
GROUP 2 ('/opt/oracle/oradata/redo02.log') SIZE 10M,
GROUP 3 ('/opt/oracle/oradata/redo03.log') SIZE 10M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/opt/oracle/oradata/system01.dbf'
SIZE 100M REUSE EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE
DATAFILE '/opt/oracle/oradata/tempts1.dbf'
SIZE 10M REUSE EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE undotbs
DATAFILE '/opt/oracle/oradata/undotbs01.dbf'
SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
It gave me error on line 17:
DATAFILE '/opt/oracle/oradata/tempts1.dbf'
*
ERROR at line 17:
ORA-02236: invalid file name
Why is it invalid ?
Thanks for any help.