Re: Any caveats about droping/recreating temp tablespce?

In <1118675468.355990.186850_at_z14g2000cwz.googlegroups.com> "Mark D Powell" <Mark.Powell_at_eds.com> writes:

>I vote with Sybrand. For an old 7.3.4 database you would also want you
>temporary tablespace to have been created using: create tablespace temp
>temporary.

>I believe the temporary mode was new with 7.3 and it reduced contention
>on the single database wide ST lock used to control space allocation by
>allocating a single temp segment on first use and then expanding it as
>necessary. Multiple user session obtained their temp space from within
>the single defined temp segment covered by temporary table locks rather
>then the ST lock.

>If you do not use the keyword temporary then you get the default
>permanet value and space allocation within the temporary tablespace
>worked like it did with prior versions.

>HTH -- Mark D Powell --

Thanks to both of you for your advice.

I'll probably take a crack at this tommorow.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin