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

You May Also Like

TNS-01106: Listener using listener name has already been started
Change dbsnmp password for target db in oem 12c
Steps for upgrading oracle database to 19c using DBUA
How to flashback a Pluggable database ( PDB) in oracle 12.2
How to enable flash recovery area in oracle database
SGA TARGET ADVISORY IN ORACLE
Ansible script to run script on remote server and fetch the output
CONTENT parameter in datapump
OGG-00665 OCI Error describe for query
Steps for upgrading weblogic 12.1.2 to 12.1.3

From This Website

Shell script for monitoring blocking sessions
Generate custom report from OEM cloud control
How to monitor parallel queries in oracle db
How to install oracle client in silent mode using response file
Enable DDL replication in goldengate
Useful DGMGRL commands in oracle dataguard
shell script for file system alert
Flashback primary database in dataguard environment
How to use oratop tool for oracle database monitoring
_use_adaptive_log_file_sync parameter in oracle