Tablespaces Crazy Facts || Oracle DBA

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]