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

You May Also Like

How to change flash recovery area location
shell script for file system alert
Shell script to report failed login attempt in oracle
How to find execution history of an sql_id
ERROR: No checkpoint table specified for ADD REPLICAT
TNS-12542: TNS:address already in use
Get sid from ospid
Upgrade grid infrastructure to 19C oracle
OGG-01028 partial record at sequence extract abended
Rollback database patch in oracle 12c

From This Website

Shell script to delete old archives using RMAN
How to create encrypted tablespace in PDB( oracle 12c)
_use_adaptive_log_file_sync parameter in oracle
How to move controlfile to a new location in oracle
What is colored sql_id in dba_hist_colored_sql
Steps for upgrading weblogic 12.1.2 to 12.1.3
Useful ADRCI commands in oracle
ERROR: permission denied for schema in postgres
how to change archivelog destination in oracle
Shell script to monitor lag in standby datbase using dgmgrl