Re: create temporary tablespace question

Hi,

The first option always remain as temporary tablespaceand can not be made permanent. but whereas the second option can be altered later as permanent.

Rgds,

Muthaiah
At 10:45 PM 6/4/01 -0800, you wrote:
Hi all,

What is the different between:

        CREATE

TEMPORARY TABLESPACE temp
                bla
                bla
        ;

        and

        CREATE

TABLESPACE temp
                bla
                bla
                TEMPORARY
        ;

Thank You

Sinardy

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Sinardy Xing
  INET: sinardyxing_at_bcsis.com

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


Muthaiah
Chinnaveerappan (Muths),
Systems Analyst,
Chennai, India.
Tel      : 91-44-2435034
Email :
cvmuthaiah_at_yahoo.com