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?
Expert response: Does 9iR2 release temporary tablespace that is no longer used?
Do you have an idea for a quiz question topic? Let us know!
This was first published in September 2003