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

You May Also Like

How to setup dataguard broker configuration (DG broker) in 12c
How to generate AWR report in RAC
how to Print execution time of tasks in ansible
How to change flash recovery area location
How to install OPatch in ORACLE RAC
oracleasm utility for ASMLIB
Shell script to report failed login attempt in oracle
How to install oracle client in silent mode using response file
CONTENT parameter in datapump
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only

From This Website

ENABLE_DDL_LOGGING in oracle 12c
Blackout targets in OEM 12c cloud control
How to generate AWR report in RAC
Ansible script to run script on remote server and fetch the output
How to use oratop tool for oracle database monitoring
Steps for upgrading oracle database to 19c using DBUA
Standby redologs in oracle dataguard
Open wallet automatically after starting the database
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
Oracle database Security Assessment Tool