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.
ORA- TROUBLESHOOTING