ORA-32774: More Than One File Was Specified For 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-32774: More Than One File Was Specified For Bigfile Tablespace

Problem :

While creating bigfile tablespace with multiple datafile, got this error as ORA-32774: more than one file specified

Solution :

This is because bigfile tablespace can contain only one datafile. So create the bigfile tablespace with only one datafile. 
SQL> create bigfile tablespace BIGTBS datafile ‘/data/app/oracle/oradata/BSDMSIT2/BIGTBS01.dbf’ size 1G,
Tablespace created.
ORA-32771: Cannot Add File To Bigfile Tablespace
ORA-01466: Unable To Read Data