| Temporary Tables [message #59465] |
Mon, 24 November 2003 04:34  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi,
Plz tell me that the temporary tables which we create, stores in permanent or temporary tablespace. Moreover how its extent management is managed?
Thanx in advance.
|
|
|
|
| Re: Temporary Tables [message #59470 is a reply to message #59465] |
Mon, 24 November 2003 09:30  |
Adrian Billington
Messages: 139
Registered: December 2002
|
Senior Member |
|
|
As their name suggests, the data you write to a temporary table will be stored in your default temporary tablespace for either the life of a transaction or session. Extent management will depend on how your temporary tablespace is created ( i.e. whether it is a "standard" dictionary managed tablespace with temporary contents or a locally managed "true" temporary tablespace).
Regards
Adrian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
