ANKUSH THAVALI21 Dec, 20230 Comments1 Min ReadORA-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. Oracle DBAShare: ORA-32771: Cannot Add File To Bigfile TablespaceORA-01466: Unable To Read Data