The Oracle Guru Answer #8

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: