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.
