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

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

You May Also Like

Enable DDL replication in goldengate
shell script for file system alert
How to get the execution plan for a SQL between two AWR snapshots
COMPRESSION in datapump oracle
ORA-32773: operation not supported for smallfile tablespace
COLS & COLSEXCEPT FILTER in goldengate
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
SETUP ORACLE 18C DATABASE - STEP BY STEP
Change dbsnmp password for target db in oem 12c

From This Website

How to find execution history of an sql_id
Purge AUD$ table using DBMS_AUDIT_MGMT
How to change flash recovery area location
How to deinstall/cleanup standalone grid infrastructure
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
ORA-32773: operation not supported for smallfile tablespace
Useful TFACTL commands
Shell script to delete old archives using RMAN
Apply database patch from OEM Cloud control
Setting up Table replication in oracle goldengate