The keyword is not necessary. It is up to you to
decide whether to use it or not. Of course why use a
permanent tablespace for something that is temporary.
A TEMP tablespace can be permanent or temporary.


benny

--- Prakriteswar Santikary <[Email Address Removed] Hi,
>
> I have a statement like this in my createdb.sql.
>
>
> CREATE TABLESPACE TEMP ....
>
> The script is assigning this as the temporary
> tablespace to many users like
> this.
>
> ALTER USER test1 TEMPORARY TABLESPACE TEMP.
>
> My question is:
>
> Don't I need to use the word 'TEMPORARY' while
> creating this tablespace ?
>
> thanks
> Santi
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Oracle LazyDBA home page