Hi Helmut,
here is the breakdown
Tablespaces
1 DMT (dictionary managed)
a> Normal
b> temporary(only temp objects)
2. LMT temporary tblspces (True temp tblspces)
syntax: create temporary tablespace ....
The behaviour of this is similar to the /tmp of
unix as temp files gets flushed (gone) on db bounce.
Also rman full backups ignore these which is a big
plus. these are visible using v$tempfile or
dba_temp_files or somin like that
Deepak
--- "Daiminger, Helmut"
<[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm getting kinda confused concerning the two types
> of temporary
> tablespaces:
>
> create tablespace NAME temporary... is the "old" way
> of creating a temporary
> tablespace for sorting purposes. It only allows for
> sort segments to be
> stored there. And it can only be dictionary managed,
> right?
>
> create temporary tablespace NAME tempfile... is the
> "new" way for it. It can
> either be dictionary managed or locally managed.
> But the complete reference says that this tablespace
> will only be used for
> temporary tables.
> Does this tablespace also allow for sort segments?
>
> Or do I need both types of tablespaces?
>
> This is 8.1.7 on Sun Solaris.
>
> Thanks,
> Helmut
>
>
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
