SOLVED

ORA-32771: Cannot Add File To Bigfile Tablespace

Asked by OracleDba••13 views•oracle
1
2
3
4
5
ORA-32771: Cannot Add File To Bigfile Tablespace

Problem :

While adding a datafile to a table space , got the error – ORA-32771: cannot add file to bigfile tablespace.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
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=’BIGTBS’;

BIG

———————– —

YES
OracleDba•

Post Your Solution