Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY
Hi,
> permanent tablespace. And if you have 8i, no-one in their right minds would
> do anything other than have locally managed tablespace for the temporary
> tablespace (makes iniital extent allocation even faster).
would it be that after 8i, we should be using locally managed tablespaces for data/indices too?..
[yes I have read things and understood why they are GOOD. but perhaps you know of disadvantages that I do not.]
regards
r.
Received on Wed Feb 07 2001 - 08:05:27 CST
![]() |
![]() |