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

Pro+

Features

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

0 comments

Oldest 

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:

-ADS BY GOOGLE

This Content Component encountered an error
Close