- 21 Dec, 2023
- 0 Comments
- 1 Min Read
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.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=’BIGTBS’; BIG ———————– — YES