Re: what is error invalid file name ORA-02236 ?

You are right ! Thank you so much !!! :)

James

spencer wrote:

> remove the comma after the last logfile.
>
> you've got an extra comma at the end of
> the line with the fourth logfile. the next line
> is being interpreted as a datafile name for
> a fifth log file, which is not what you want.
>
> sometimes it's the simple things...
>
> "James Lee" <Jameslee_at_comsys.com> wrote in message
> news:39179726.ACBA062F_at_comsys.com...
> > I tried to create a database, but got invalid file name error
 ORA-02236.
> > Here is the log file:
> >
> > >ORACLE instance started.
> > >Total System Global Area 11901612 bytes
> > >Fixed Size 47788 bytes
> > >Variable Size 10653696 bytes
> > >Database Buffers 1126400 bytes
> > >Redo Buffers 73728 bytes
> > >datafile 'D:\orant\database\sys1mydb.ora' size 10M reuse
 autoextend on
> > >*
> > >ORA-02236: invalid file name
> > >create tablespace user_data
> > >*
> > >ORA-01109: database not open
> >
> > and create_database script used as:
> >
> ****************************************************************
> ****
> > startup nomount pfile=d:\Orant\DATABASE\initmydb.ora
> > -- Create database
> > create database mydb
> > logfile 'D:\orant\database\log1mydb.ora' size 1M reuse,
> > 'D:\orant\database\log2mydb.ora' size 1M reuse,
> > 'D:\orant\database\log3mydb.ora' size 1M reuse,
> > 'D:\orant\database\log4mydb.ora' size 1M reuse,
> > datafile 'D:\orant\database\sys1mydb.ora' size 10M reuse
 autoextend on
> > next 10M maxsize 200M character set WE8ISO8859P1;
> >
> > create tablespace user_data
> > datafile 'D:\orant\database\usr1mydb.ora' size 3M reuse
 autoextend on
> > next 5M maxsize 150M;
> > create tablespace rollback_data
> > datafile 'D:\orant\database\rbs1mydb.ora' size 5M reuse
 autoextend on
> > next 5M maxsize 150M;
> > create tablespace temporary_data
> > datafile 'D:\orant\database\tmp1mydb.ora' size 2M reuse
 autoextend on
> > next 5M maxsize 150M;
> >
> > create rollback segment rb_temp storage (initial 100 k next
 250 k); --
> > Create additioanal tablespaces ...
> > alter rollback segment rb_temp online;
> >
> > alter user system default tablespace user_data;
> >
> > create rollback segment rb1 storage(initial 50K next 50K)
> > tablespace rollback_data;
> > create rollback segment rb2 storage(initial 50K next 50K)
> > tablespace rollback_data;
> > create rollback segment rb3 storage(initial 50K next 50K)
> > tablespace rollback_data;
> > create rollback segment rb4 storage(initial 50K next 50K)
> > tablespace rollback_data;
> >
> >
> ****************************************************************
> *
> >
> > Thanks for any help!
> >
> > James
> >
> >
Received on Wed May 10 2000 - 00:00:00 CDT