Viswamitra's blog

How to create tablespace with multiple datafiles :

I tried to add like below but got the error

SQL> create tablespace T
  2  datafile ‘+DATA’ size 4m,
  3  datafile ‘+DATA’ size 4m;
datafile ‘+DATA’ size 4m
*
ERROR at line 3:
ORA-02197: file list already specified

SQL> create tablespace T datafile ‘+DATA’ size 4m autoextend off,’+DATA’ size 4m autoextend off;

Tablespace created.

How to add multiple datafiles to existing tablespace :-

SQL> alter tablespace T add datafile ‘+DATA’ size 4m autoextend off , ‘+DATA’ size 4m autoextend off;

Tablespace altered.