August 2011
Intermediate to advanced
576 pages
16h 12m
English
Oracle uses a temporary tablespace as a “scratch pad” area to perform sort operations that cannot be done in the memory. Oracle also uses the temporary tablespace to create TEMP tables. Any user who is not assigned a temporary tablespace explicitly will use the default temporary tablespace. Starting with Oracle Database 10g R1, DBCA automatically creates a default temporary tablespace. When you’re creating a database with a locally managed system tablespace, a default temporary tablespace must be specified.
Starting with Oracle Release 10g, you can define a temporary tablespace group that can be used wherever a temporary tablespace is used. The use of a temporary tablespace group in an Oracle RAC environment ...
Read now
Unlock full access