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

You May Also Like

SKIP_CONSTRAINT_ERRORS as DATA_OPTION in impdp
Find user commits per minute in oracle database
how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
how to change archivelog destination in oracle
Apply database patch from OEM Cloud control
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
Useful flashback related commands
how to Print execution time of tasks in ansible
DEFERRED_SEGMENT_CREATION parameter in oracle
ORA-16855: transport lag has exceeded specified threshold

From This Website

OGG-00665 OCI Error describe for query
Rollback database patch in oracle 12c
oraversion utility in oracle 18c - New feature
Get sid from ospid
What is colored sql_id in dba_hist_colored_sql
How to get the execution plan for a SQL between two AWR snapshots
Query clause in oracle datapump expdp
Hive Installation with derby
COLS & COLSEXCEPT FILTER in goldengate
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump