PROBLEM:

While creating bigfile tablespace with multiple datafile, got error as ORA-32774: more than one file specified

SQL> create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSIT2/bigts01.dbf’ size 1G,
‘/dmdata02/oradata/BSDMSIT2/bigts02.dbf’ size 1g;

create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSIT2/bigts01.dbf’ size 1G,
*
ERROR at line 1:
ORA-32774: more than one file was specified for bigfile tablespace BIGTS

SOLUTION:

This is because bigfile tablespace can contain only one datafile. So create the bigfile tablespace with only one datafile.

SQL> create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSIT2/bigts01.dbf’ size 1G,

Tablespace created.

However for standard table space(i.e smallfile tablespace we can create tablespace with multiple datafiles )

create tablespace SMALLTS datafile ‘/dmdata02/oradata/BSDMSIT2/smallts01.dbf’ size 1G,
‘/dmdata02/oradata/BSDMSIT2/smallts02.dbf’ size 1g;

Tablespace created.