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

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

You May Also Like

How to use oratop tool for oracle database monitoring
OGG-01028 partial record at sequence extract abended
_use_adaptive_log_file_sync parameter in oracle
How to flashback a Pluggable database ( PDB) in oracle 12.2
WHAT IS SQL PROFILE IN ORACLE
What is colored sql_id in dba_hist_colored_sql
How to setup dataguard broker configuration (DG broker) in 12c
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
Shell script to monitor asm diskgroup usage
how to send mail using utl_mail in oracle 11g

From This Website

How to install trace file analyzer( TFACTL)
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
Find the active transactions in oracle database
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
EMCLI command - OEM 12C
How to keep or delete columns/Variable of a data frame in R
How to generate ADDM report
Steps for upgrading oracle database to 19c using DBUA
Find user commits per minute in oracle database
How to recreate MGMT database in ORACLE 12C GRID