Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02236 invalid file name during database creation

474257Dec 28 2005 — edited Dec 28 2005
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2006
Added on Dec 28 2005
1 comment
1,782 views