SOLVED

ORA-32774: More Than One File Was Specified For Bigfile Tablespace

Asked by OracleDba••13 views•oracle
1
2
3
4
5
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
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.
OracleDba•

Post Your Solution