| Temp tablespace [message #172629] |
Wed, 17 May 2006 07:23  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
We can Create temporary tablespaces by using the CREATE TABLESPACE or CREATE TEMPORARY TABLESPACE.
What is the difference between these two methods of creating temporary tablespace?
What is the pros & cons of each method?
|
|
|
|
| Re: Temp tablespace [message #172640 is a reply to message #172629] |
Wed, 17 May 2006 08:06  |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
The CREATE TABLESPACE...TEMPORARY will create a DICTIONARY managed temporary tablespace. However, if you have a DICTIONARY managed SYSTEM tablespace, you will not be able to create a temporary tablespace using this method.
It is recommended that you create locally managed temporary tablespaces containing tempfiles by using the CREATE TEMPORARY TABLESPACE statement. The creation of new dictionary-managed tablespaces is scheduled for desupport.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
