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 last published in September 2003

Dig Deeper on Oracle DBA jobs, training and certification

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close