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

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

You May Also Like

How to monitor parallel queries in oracle db
How to recreate physical standby controlfile
Generate custom report from OEM cloud control
DEFERRED_SEGMENT_CREATION parameter in oracle
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
Shell script to delete old archives using RMAN
Upgrade database using OEM 12C cloud control
Hive installation with mysql database
Shell script to report failed login attempt in oracle
Oracle database Security Assessment Tool

From This Website

How to change flash recovery area location
How to flashback a Pluggable database ( PDB) in oracle 12.2
_use_adaptive_log_file_sync parameter in oracle
Unified audit trail in Oracle 12c
ORA-32771: cannot add file to bigfile tablespace
orapwd tool for password file in oracle
ERROR: permission denied for schema in postgres
resumable_timeout parameter in oracle database
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
How to find cpu and memory information of oracle database server