How to fix the Oracle error ORA-32774: more than one file was specified for bigfile tablespace string?

In this post, you’ll learn more about the Oracle ErrorORA-32774: more than one file was specified for bigfile tablespace string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-32774: more than one file was specified for bigfile tablespace string

Reason for the Error ORA-32774: more than one file was specified for bigfile tablespace string

More than one datafile or tempfile was specified in CREATE TABLESPACE command for a bigfile tablespace.

How to fix the Error ORA-32774: more than one file was specified for bigfile tablespace string ?

You can fix this error in Oracle by following the below steps

Change command to contain only one file or create a smallfile tablespace instead.