RE: temporary tablespace

Your second assertion isn't exactly correct.

CREATE TEMPORARY TABLESPACE has to be locally managed. Correct.

But
CREATE TABLESPACE ... TEMPORARY cannot be locally managed. It has to be dictionary.

Conversely, if you create a 9.2.0. database where the SYSTEM tablespace is locally managed, you cannot use CREATE TABLESPACE .. TEMPORARY [as an LMT System does not allow any Dictionary-Managed TBS]. In fact if you are creating a database with an LMT SYSTEM, you MUST also create a DEFAULT TEMPORARY TABLESPACE. To add to the complication, unlike earlier when you could create a tablespace with
Contents PERMANENT and then assign that as a user's temporary tablespace [ie, CREATE TABLESPACE MYTEMP datafile ... PERMANENT; ALTER USER MYUSER TEMPORARY TABLESPACE MYTEMP],
now a user's temporary tablespace cannot be one with PERMANENT objects it has to be a temporary tablespace. Since 9i's LMT System TBS only allows CREATE TEMPORARY TABLESPACE with LMT, the CREATE TABLESPACE .. TEMPORARY will certainly be gone in 10[whatever].

Hemant

At 01:42 PM 12-05-03 -0800, you wrote:
>Create temporary tablespace = temporary + locally managed
>Create tablespace ..Temporary = temporary + <dictionary or locally managed>
>
>My guess it will not disappear soon since it's not a big burden for Oracle
>to continue supporting it.
>
>Waleed
>
>-----Original Message-----
>Sent: Monday, May 12, 2003 5:07 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>With the introduction of a real temporary tablespace (create temporary
>tablespace ... instead of create tablespace ... temporary).
>Will the former form (create tablespace ... temporary) will be desupport ?
>
>
>
>Stephane Paquette
>Administrateur de bases de donnees
>Database Administrator
>Standard Life
>www.standardlife.ca
>Tel. (514) 499-7999 (7470)
> (514) 925-7187
>stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).