Re: TEMPORARY tablespace -- what it really means

If you had done any kind of programming where you had to write a sort routine, you will relate to this much easier. Any SQL that requries a SORT operation uses the TEMPORARY tablespace to store intermediate results of the sort. Some SQL / constructs that may use the TEMPORARY tablespace are ORDER BY, CREATE INDEX, UNION etc.
In fact, there is nothing that will stop you from creating a table in TEMPORARY tablespace, as well as a non TEMPORARY tablespace may be assigned as a staging area for SORTs, though any DBA would shoot that idea down. The classic abuse of SYSTEM tablespace is to let it be the TEMPORARY tablespace for a user.

Good luck,
CM

In article <6kt96a$ji7$2_at_gte1.gte.net>,   johnvue_at_gte.net wrote:
>
> I'm trying to understand more thoroughly the effect of designating a
> tablespace as TEMPORARY. Besides the surface level knowledge that you
> can't put permanent objects in TEMPORARY tablespaces what else does
> Oracle internally do for you?
>
> I came across this statement:
>
> "Oracle 7.3 introduced a new temporary tablespace type especially
> designed to tune Oracle sorting. It achieves this by eliminating
> serialization of space management."
>
> What does paragraph mean?
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 14:56:21 CDT