PROBLEM:

While creating bigfile tablespace with multiple datafile, got error as ORA-32774: more than one file specified

SQL> create bigfile tablespace BIGTS datafile -/dmdata02/oradata/BSDMSIT2/bigts01.dbf- size 1G,
-/dmdata02/oradata/BSDMSIT2/bigts02.dbf- size 1g;

create bigfile tablespace BIGTS datafile -/dmdata02/oradata/BSDMSIT2/bigts01.dbf- size 1G,
*
ERROR at line 1:
ORA-32774: more than one file was specified for bigfile tablespace BIGTS

SOLUTION:

This is because bigfile tablespace can contain only one datafile. So create the bigfile tablespace with only one datafile.

SQL> create bigfile tablespace BIGTS datafile -/dmdata02/oradata/BSDMSIT2/bigts01.dbf- size 1G,

Tablespace created.

However for standard table space(i.e smallfile tablespace we can create tablespace with multiple datafiles )

create tablespace SMALLTS datafile -/dmdata02/oradata/BSDMSIT2/smallts01.dbf- size 1G,
-/dmdata02/oradata/BSDMSIT2/smallts02.dbf- size 1g;

Tablespace created.

ORA- TROUBLESHOOTING


Related Topics

ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
ORA-32771: cannot add file to bigfile tablespace
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
TNS-01106: Listener using listener name has already been started
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
TNS-12542: TNS:address already in use
ORA-01536: space quota exceeded for tablespace
ORA-32773: operation not supported for smallfile tablespace
ORA-16855: transport lag has exceeded specified threshold
ORA-32774: more than one file was specified for bigfile tablespace

You May Also Like

Defgen utility in Oracle goldengate
SKIP_CONSTRAINT_ERRORS as DATA_OPTION in impdp
Shell script to monitor lag in standby datbase using dgmgrl
How to find cpu and memory information of oracle database server
How to create encrypted tablespace in PDB( oracle 12c)
How to flashback a Pluggable database ( PDB) in oracle 12.2
Obey command in goldengate
Upgrade database using OEM 12C cloud control
Useful TFACTL commands
Alert log rotation script in oracle

From This Website

How to change sysman password for oracle 12c cloud control
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
Shell script for monitoring blocking sessions
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
How to move spfile from file system to ASM in RAC
Display sql_id of the sql, using set feedback in oracle 18C - New feature
How to drop SQL baselines in oracle
ORA-32773: operation not supported for smallfile tablespace
ERROR: No checkpoint table specified for ADD REPLICAT
ORA-16855: transport lag has exceeded specified threshold