temporary tablespace - managing extents

Hello

CREATE TEMPORARY TABLESPACE temp TEMPFILE '/usr/f1' SIZE 2M AUTOEXTEND ON;

Does this tablespace has locally or dictionary managed extents ?

I found in documentation clausule EXTENT MANAGEMEMENT LOCAL, and there is no clausule 'EXTENT MANAGEMEMENT DICTIONARY' what would suggest that by default temporary tablespace is dictionary managed. But in other documentation i found that temporary tablespace has locally managed extents by default (how/can i create dictionary managed tablespace in such case?).

Thanx
Michal Received on Wed Feb 09 2005 - 04:02:43 CST