Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The reason we got this error is because the large file tablespace can contain only one data file.
ERROR :
ORA-32774: More Than One File Was Specified For Bigfile Tablespace
1 2 3 4 5 6 7 8 9 | SAMPLE : SQL> create bigfile tablespace MYBIGTS datafile ‘/oradata/ABUZERDB/bigts01.dbf’ size 5G, ‘/oradata/ABUZERDB/bigts02.dbf’ size 5g; create bigfile tablespace MYBIGTS datafile ‘/oradata/ABUZERDB/bigts01.dbf’ size 5G, * ERROR at line 1: ORA-32774: more than one file was specified for bigfile tablespace MYBIGTS |
SOLUTION :
Bigfile tables can contain only one datafile.
