Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: temporary tablespace

RE: temporary tablespace

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 13 May 2003 11:26:50 -0800
Message-ID: <F001.00597DE8.20030513112650@fatcity.com>


I checked the Oracle 9i doc :
Note: Oracle Corporation strongly recommends that you create locally managed temporary tablespaces containing tempfiles by using the CREATE TEMPORARY TABLESPACE statement. The creation of new dictionary-managed tablespaces is scheduled for desupport.

I've opened a TAR but the support analyst did not know when old style temporary tablespace will be desupport.
I was asking as my boss wants to know when the old style is desupported when we decide to change our ways of doing things.

Stephane

-----Original Message-----
Waleed
Sent: Tuesday, May 13, 2003 2:37 PM
To: Multiple recipients of list ORACLE-L

Thanks for the correction. For some reason I thought I had the combination of LMT + TEMPORARY in 8i when I was having problems with releasing the temp space but probably I made it permanent local.

Thanks,

Waleed

-----Original Message-----
Sent: Tuesday, May 13, 2003 12:27 PM
To: Multiple recipients of list ORACLE-L

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).
--
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).

-- 
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).
Received on Tue May 13 2003 - 14:26:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US