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

You May Also Like

resumable_timeout parameter in oracle database
How to find execution history of an sql_id
how to Print execution time of tasks in ansible
CONTENT parameter in datapump
Upgrade database using OEM 12C cloud control
SQLCL UTILITY IN ORACLE
orapwd tool for password file in oracle
How to change spfile in Oracle RAC.
How to enable active dataguard in physical standby database
Hive installation with mysql database

From This Website

how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
SET ROWLIMIT in oracle 18C - New feature
Useful ADRCI commands in oracle
Steps To Set Up Master Slave Replication in MySQL
How to change spfile in Oracle RAC.
LREG Background Process in oracle
How to enable active dataguard in physical standby database
How to install trace file analyzer( TFACTL)
Shared Pool Advisory in oracle
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh