PROBLEM:
While adding a datafile to a table space , got the error - ORA-32771: cannot add file to bigfile tablespace
SQL> ALTER TABLESPACE BIGTS add datafile -/dmdata02/oradata/BSDMSIT2/bigts02.dbf- size 1G;
ALTER TABLESPACE BIGTS add datafile -/dmdata02/oradata/BSDMSIT2/bigts02.dbf- size 1G
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SOLUTION:
A bigfile tablespace can contain only one datafile and no other datafile can be added to that.
SQL> select BIGFILE from dba_tablespaces where tablespace_name=-BIGTS-;
BIG
-------- -
YES
TROUBLESHOOTING