How to create a tablespace with multiple datafiles?

Question

I'm using the following script to create a new tablespace with three datafile with 4 MB size for each.

create tablespace homeworkts 
       datafile 'D:\oradata\orcl\df1.dbf' size 4m , 
       datafile 'D:\oradata\orcl\df2.dbf' size 4m,
       datafile 'D:\oradata\orcl\df3.dbf' size 4m;

But it keeps giving me the error

invalid file name

for the second datafile.

Why?

Answer 1

Reading create tablespace syntax you should write:

create tablespace homeworkts 
datafile 'D:\oradata\orcl\df1.dbf' size 4m, 
         'D:\oradata\orcl\df2.dbf' size 4m, 
         'D:\oradata\orcl\df3.dbf' size 4m;

You should write datafile just for once, then all your file specification separated by commas:

Edited on 2018' Still valid for current create tablespace on release 18 oracle version.