That syntax should be

create temporary tablespace <TS_NAME>
tempfile ...........

The word 'temporary' is required with 'create' to define 'tempfiles'
Hope it was typo....

Regards,

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: PALLAVI KASLIWAL [SMTP:[Email Address Removed] Sent: Monday, July 30, 2001 5:12 PM
> To: LazyDBA.com Discussion
> Subject: Re: temporary tablespace
>
> Hi,
>
> In oracle 8i you have to specify "tempfile" instead of "datafile"
> while creating the temporary tablesapce .
>
> For eg
>
> create tablesapce temp
>
> tempfile '/u01/.../.../temp
>
> size 400M
>
> 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.
>
> Pallavi.
>
>
>
> From: Benny Pei
> To: "LazyDBA.com Discussion"
> Subject: Re: temporary tablespace
> Date: Mon, 30 Jul 2001 14:18:06 -0700 (PDT)
> 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
> wrote:
> > 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 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
>
> _____
>
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> <http://go.msn.com/bql/hmtag_itl_EN.asp>
>
> -------- 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
Oracle LazyDBA home page