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