- 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 specifiedSolution :
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.
