Oracle Solution for Error ora-32772

Solution for Oracle Error ORA-32772

ORA-32772: BIGFILE is invalid option for this type of tablespace

What triggered the Error:

An attempt was made to create a bigfile tablespace that is dictionary managed or locally managed with manual segment-space management.

What should we do to fix it:

Either change the tablespace type to locally managed with automatic segment-space management, or create a SMALLFILE tablespace instead.