Re: Creating Tablespace with multiple Datafiles.

In article <a079a49c.0212090813.4e845e2d_at_posting.google.com>, jigarparsana_at_yahoo.com says...
> Hi ,
>
> I am trying to create a tablespace with multiple data files.here
> is the statement i am using
>
> CREATE TABLESPACE RBSP
> DATAFILE 'D:\oracle\oradata\epidb\rbsp01.dbf' SIZE 500M,
> DATAFILE 'D:\oracle\oradata\epidb\rbsp02.dbf' SIZE 100M
> AUTOEXTEND ON NEXT 5120K MAXSIZE 500M
> MINIMUM EXTENT 512K
> DEFAULT STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS 200
> OPTIMAL 15M);
>
> this statement is actully a part of the database creation script that
> was prepared by our dba. apparantly everytime i try to execute this
> script the above statement gives an error saying "invalid file name"
> for the second datafile. I dont know what is going wrong here....any
> help will be highly appreciated.
>

You only specify the DATAFILE keyword once:

CREATE TABLESPACE RBSP

	DATAFILE 'D:\oracle\oradata\epidb\rbsp01.dbf' SIZE 500M,
       	  'D:\oracle\oradata\epidb\rbsp02.dbf' SIZE 100M
		   AUTOEXTEND ON NEXT 5120K MAXSIZE 500M