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

You May Also Like

Apply database proactive bundle patch in RAC using manual process
Oswatcher tool for collecting server diagnostic information
Shell script to delete old archives using RMAN
How to rename Columns in R
Useful ADRCI commands in oracle
Perform Flashback in pluggable database(PDB) in oracle 12.2
Apply database patch from OEM Cloud control
EMCLI command - OEM 12C
How to monitor parallel queries in oracle db
_optimizer_ignore_hint

From This Website

How to install OPatch in ORACLE RAC
Install oracle enterprise manager cloud control 12c
How to create user in MySQL Database
How to multiplex control file in standalone database
SGA TARGET ADVISORY IN ORACLE
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
How to Downgrade oracle 19C Grid to 12C GRID
Alert log rotation script in oracle
Lock account automatically with INACTIVE_ACCOUNT_TIME
Script to get cpu usage and wait event information in oracle database