• Oracle

    Oracle Tablespace-05

    Tablespace: A database is divided into one or more logical storage units called tablespaces. All tablespaces, including the SYSTEM tablespace, can be locally managed. https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7116328455352 http://www.orafaq.com/node/3.   Types: 1.System tablespace 2. Non System tablespace System SysAUX Undo Temporary — A different block size object cannot move between the tablespace. — All the data file name should be created as unique. Since, it might have some issues in cloning a database. TEMPFILEs are not fully initialized (sparse). When you create a TEMPFILE, Oracle only writes to the header and last block of the file. This is why it is much quicker to create a TEMPFILE than to create a normal database…