What are the different types of Table spaces?

devquora
devquora

Posted On: Jun 24, 2021

 

There are three types of tablespaces. These are as follows:

  • Permanent Tablespace - It is used to store your user and application data.
  • Undo Tablespace - It is used to roll back transactions, provide read consistency, help with database recovery, and enable features such as Oracle Flashback Query. 
  • Temporary Tablespace - It is used for storing temporary data, as would be created when SQL statements perform sort operations.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mainframe Interview Questions

    What is the difference between LINK and XCTL?

    Link is used to go from one module to another and then return to the first module such that the link to a module is used to provide the first some data. Whereas XCTL is used to go from one module with...

    Mainframe Interview Questions

    What is the difference between the MRO & ISC?

    MRO or Multiregion operation is influenced by the intercommunication facilities that you use with the connection and by your management of the connection. Whereas ISC or intersystem communication s sh...

    Mainframe Interview Questions

    What happens when a CICS command contains the NOHANDLE option?

    In CICS the NOHANDLE option is used to suspends the error handling that was specified in previous EXEC CICS HANDLE CONDITION commands but only for the command on which you put the NOHANDLE....