CODEWITHSUNDEEP
sqloracle-database
Goku
Goku

Reputation: 441

When is a temporary tablespace used?

In which cases a temporary tablespace is required? It's mentioned in Oracle documentation but I do not understand why it's being used.

I'm using Oracle 12c r2

Thanks in advance, Petar

Upvotes: 0

Views: 145

Answers (1)

BobC
BobC

Reputation: 4432

Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory. This is just one of many examples.

Upvotes: 1

Related Questions