PROBLEM:

While adding a datafile to a table space , got the error - ORA-32771: cannot add file to bigfile tablespace

SQL> ALTER TABLESPACE BIGTS add datafile -/dmdata02/oradata/BSDMSIT2/bigts02.dbf- size 1G;
ALTER TABLESPACE BIGTS add datafile -/dmdata02/oradata/BSDMSIT2/bigts02.dbf- size 1G
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace

SOLUTION:

A bigfile tablespace can contain only one datafile and no other datafile can be added to that.
SQL> select BIGFILE from dba_tablespaces where tablespace_name=-BIGTS-;

BIG
-------- -
YES

TROUBLESHOOTING


Related Topics

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

You May Also Like

Obey command in goldengate
How to keep or delete columns/Variable of a data frame in R
Alert log rotation script in oracle
Unified audit trail in Oracle 12c
Apply database proactive bundle patch in RAC using manual process
How to use expdp to export data from physical standby database
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
EMCLI command - OEM 12C
How to monitor parallel queries in oracle db
Steps for upgrading oracle database to 19c using DBUA

From This Website

Blackout targets in OEM 12c cloud control
Find pending distributed pending transactions in oracle
Steps To Set Up Master Slave Replication in MySQL
Setting up Table replication in oracle goldengate
Query clause in oracle datapump expdp
Change dbsnmp password for target db in oem 12c
Find the active transactions in oracle database
Useful DGMGRL commands in oracle dataguard
DBMS_PARALLEL_EXECUTE in oracle PL/SQL
Shell script to monitor asm diskgroup usage