Re: Temp tablespace vs. tablespace ... temp

Ed Stevens wrote:
>
> Platform: Ora 8.1.7 on NT
>
> Would someone care to enlighten me on the differences in CREATE TEMPORARY
> TABLESPACE and CREATE TABLESPACE ..... TEMPORARY.
>
> The explanation in the docs is pretty terse. As I understand it, CREATE
> TEMPORARY TABLESPACE allocates a temporary file that gets dropped and recreated
> on demand, though I don't see what creates that demand. CREATE TABLESPACE .....
> TEMPORARY creates a permanant tablespace to hold transient objects like segments
> created to perform disk sorts. I also see that local management cannot be used
> with the TEMPORARY option of CREATE TABLESPACE.
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)

The biggest benefits I can see are:

1. you can use a tempfile to have a readonly standby database
2. you don't need to backup the tempfile (you can do the same with a tspace of type temporary but it takes a little more effort during recovery)
3. its an lmt

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."