 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Temporary Tablespaces
You create a temporary tablespace to be temporary by using the
TEMPORARY keyword of the CREATE TABLESPACE and ALTER TABLESPACE
commands. It is important to note that temporary tablespaces cannot
contain permanent objects (tables, indexes, rollback segments,
etc.).
The Oracle Database Fundamentals I (1Z0-031)
and the Oracle Database Performance Tuning (1Z0-033) certification
tests will have a few questions on temporary tablespaces. Test
candidates should have a firm understanding of:
-
What the temporary tablespace is used for
-
The differences between permanent and a
temporary tablespace used for sorting
-
How to create a default temporary tablespace in
Oracle9i
-
The impact default temporary tablespaces have
on user administration
-
Where the user sorts if a default temporary
tablespace is not specified
Create Tablespace
Temporary vs. Create Temporary Tablespace
The Oracle SQL reference manual provides two
different statements to create a temporary tablespace:
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
