The Oracle Guru Were you correct? This week's answer is:
b. temporary tablespace

A temporary tablespace, according to Oracle, is a tablespace of temporary tables created during the processing of a SQL statement. This allows you to add tempfile entries in read-only mode for the purpose of making queries. You can then perform on-disk sorting operations in a read-only database without affecting dictionary files or generating redo entries.

For More Information

Expert advice: When is a temporary tablespace used?

Tip: Tablespace generation script

Expert response: Does 9iR2 release temporary tablespace that is no longer used?

Tip: Defragmenting tablespaces

Do you have an idea for a quiz question topic? Let us know!


This was first published in September 2003

Back to top