<html><div style='background-color:'><DIV>
<P>Hi,</P>
<P> In oracle 8i you have to specify "tempfile" instead of "datafile" while creating the temporary tablesapce .</P>
<P>For eg</P>
<P>create tablesapce temp</P>
<P>tempfile '/u01/.../.../temp</P>
<P>size 400M </P>
<P>and so on if you want to create a temporary tablespace otherwise it will become a permanent tablespace which I guess we do not want.</P>
<P>Pallavi.<BR><BR></P></DIV>
<DIV></DIV>
<DIV></DIV>From: Benny Pei <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: temporary tablespace
<DIV></DIV>Date: Mon, 30 Jul 2001 14:18:06 -0700 (PDT)
<DIV></DIV>
<DIV></DIV>The keyword is not necessary. It is up to you to
<DIV></DIV>decide whether to use it or not. Of course why use a
<DIV></DIV>permanent tablespace for something that is temporary.
<DIV></DIV>A TEMP tablespace can be permanent or temporary.
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>benny
<DIV></DIV>
<DIV></DIV>--- Prakriteswar Santikary <[Email Address Removed]
<DIV></DIV>> Hi,
<DIV></DIV>>
<DIV></DIV>> I have a statement like this in my createdb.sql.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> CREATE TABLESPACE TEMP ....
<DIV></DIV>>
<DIV></DIV>> The script is assigning this as the temporary
<DIV></DIV>> tablespace to many users like
<DIV></DIV>> this.
<DIV></DIV>>
<DIV></DIV>> ALTER USER test1 TEMPORARY TABLESPACE TEMP.
<DIV></DIV>>
<DIV></DIV>> My question is:
<DIV></DIV>>
<DIV></DIV>> Don't I need to use the word 'TEMPORARY' while
<DIV></DIV>> creating this tablespace ?
<DIV></DIV>>
<DIV></DIV>> thanks
<DIV></DIV>> Santi
<DIV></DIV>>
<DIV></DIV>> --------
<DIV></DIV>> Oracle documentation is here:
<DIV></DIV>> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
<DIV></DIV>> To unsubscribe: send a blank email to
<DIV></DIV>> oracledba-[Email Address Removed]
<DIV></DIV>> To subscribe: send a blank email to
<DIV></DIV>> oracledba-[Email Address Removed]
<DIV></DIV>> Visit the list archive:
<DIV></DIV>> http://www.LAZYDBA.com/odbareadmail.pl
<DIV></DIV>> Tell yer mates about http://www.farAwayJobs.com
<DIV></DIV>> By using this list you agree to these
<DIV></DIV>> terms:http://www.lazydba.com/legal.html
<DIV></DIV>>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>__________________________________________________
<DIV></DIV>Do You Yahoo!?
<DIV></DIV>Make international calls for as low as $.04/minute with Yahoo! Messenger
<DIV></DIV>http://phonecard.yahoo.com/
<DIV></DIV>
<DIV></DIV>--------
<DIV></DIV>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
<DIV></DIV>To unsubscribe: send a blank email to oracledba-[Email Address Removed]
<DIV></DIV>To subscribe: send a blank email to oracledba-[Email Address Removed]
<DIV></DIV>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
<DIV></DIV>Tell yer mates about http://www.farAwayJobs.com
<DIV></DIV>By using this list you agree to these terms:http://www.lazydba.com/legal.html
<DIV></DIV>
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>
Oracle LazyDBA home page