ORA-32771: Cannot Add File To Bigfile Tablespace

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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