Small File Tablespaces:
=======================
CREATE TABLESPACE TBS1
DATAFILE '/u01/app/oracle/oradata/DEVDB/datafile/tbs1.dbf'
SIZE 10M AUTOEXTEND ON;

CREATE UNDO TABLESPACE UNDOTBS1_NEW
DATAFILE '/u01/app/oracle/oradata/DEVDB/datafile/undotbs1_new.dbf'
SIZE 10M AUTOEXTEND ON;

CREATE TEMPORARY TABLESPACE TEMPTBS1
TEMPFILE '/u01/app/oracle/oradata/DEVDB/datafile/temptbs1.dbf'
SIZE 10M AUTOEXTEND ON;

select TABLESPACE_NAME,BIGFILE from dba_tablespaces;

BIG File Tablespaces:
=====================
CREATE BIGFILE TABLESPACE BIGTBS1
DATAFILE '/u01/app/oracle/oradata/DEVDB/datafile/bigtbs1.dbf'
SIZE 10M AUTOEXTEND ON;

CREATE BIGFILE UNDO TABLESPACE BIGUNDOTBS1_new
DATAFILE '/u01/app/oracle/oradata/DEVDB/datafile/bigfileundotbs1_new.dbf'
SIZE 10M AUTOEXTEND ON;

CREATE BIGFILE TEMPORARY TABLESPACE BIGTEMPTBS1
TEMPFILE '/u01/app/oracle/oradata/DEVDB/datafile/bigfiletemptbs1.dbf'
SIZE 10M AUTOEXTEND ON;

select TABLESPACE_NAME,BIGFILE from dba_tablespaces;

#Tablsepace #RMAN #Restore #Recover #Clone #Backup #Recovery #ASM #Administration #Database #Exadata #RAC #oracle

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848 or +91 9036478079
WhatsApp: +91 9880616848
Email: [email protected]