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

You May Also Like

COMPRESSION in datapump oracle
ORA-32773: operation not supported for smallfile tablespace
Clone a database using dbca command in oracle 19c -New feature
How to drop a database in postgres
ORA-16855: transport lag has exceeded specified threshold
CONTENT parameter in datapump
OGG-01028 partial record at sequence extract abended
Shell script to monitor lag in standby datbase using dgmgrl
_use_adaptive_log_file_sync parameter in oracle
How to Downgrade oracle 19C Grid to 12C GRID

From This Website

Shared Pool Advisory in oracle
How to stop MySQL on Linux and Windows
Steps for changing public hostname for a standalone grid infrastructure
Deinstall Management Agents Oracle 12c cloud control
How to create encrypted tablespace in PDB( oracle 12c)
How to monitor parallel queries in oracle db
How to change the case (Lower to Upper and Vice Versa) in R
How to flashback a Pluggable database ( PDB) in oracle 12.2
oracleasm utility for ASMLIB
Script to get cpu usage and wait event information in oracle database