Create a new tablespace - Oracle Tablespaces

Q.  Which SQL statement from the following is used to create a new tablespace?
- Published on 12 Aug 15

a. CREATE TABLESPACE
b. CREATE TEMPORARY TABLESPACE
c. CREATE UNDO TABLESPACE
d. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - The CREATE TABLESPACE statement is used to create a tablespace, which is an allocation of space in the database that can contain schema objects.

    - There are 3 types of TABLESPACE

    - Permanent tablespace - It contains persistent schema objects. Objects in permanent tablespaces are stored in datafiles.

    - Undo tablespace - It is a type of permanent tablespace used by Oracle Database to manage undo data if you are running your database in automatic undo management mode. Oracle strongly recommends that you use automatic undo management mode rather than using rollback segments for undo.

    - Temporary tablespace - It contains schema objects only for the duration of a session. Objects in temporary tablespaces are stored in tempfiles.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)