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 AvatarKiran Dalvi
  • 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.