The Oracle Guru Answer #8

Are you an Oracle guru? Take our quiz and see how much you really know about Oracle features and applications.

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

Dig deeper on Oracle DBA jobs, training and certification



Enjoy the benefits of Pro+ membership, learn more and join.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:


This Content Component encountered an error