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-32773: operation not supported for smallfile tablespace
ORA-32771: cannot add file to bigfile tablespace
TNS-12542: TNS:address already in use
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) 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-01106: Listener using listener name has already been started
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
ORA-32774: more than one file was specified for bigfile tablespace

You May Also Like

OGG-01028 partial record at sequence extract abended
Find sessions consuming lot of CPU
COLS & COLSEXCEPT FILTER in goldengate
Useful TFACTL commands
How to Downgrade oracle 19C Grid to 12C GRID
OUTBOUND_DBLINK_PROTOCOLS in oracle 12.2
Standby redologs in oracle dataguard
How to install oracle client in silent mode using response file
How to install trace file analyzer( TFACTL)
TNS-12542: TNS:address already in use

From This Website

Shell script to monitor lag in standby datbase using dgmgrl
PDB Lockdown Profiles in Oracle 12.2
Find sessions consuming lot of CPU
Script to get cpu usage and wait event information in oracle database
Useful ADRCI commands in oracle
Steps for upgrading oracle database to 19c using DBUA
SGA TARGET ADVISORY IN ORACLE
Shell script to report failed login attempt in oracle
How to create encrypted tablespace in PDB( oracle 12c)
Query clause in oracle datapump expdp