Re: sql statement for creating tablespace

i am aware about the first and the third method of creating tablespace. what about the second one? is it much different from first method?

regards,
dotyet

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0305200511.303f1dc5_at_posting.google.com>...
> "myhome" <myhome_at_home.hk> wrote in message news:<3eca03a3_at_shknews01>...
> > i used this statement to create user:
> > create user admin identified by ADMIN
> > default tablespace ADMIN_DATA
> > temporary tablespace TEMP_ADMIN
> > quota unlimited on ADMIN_DATA
> > quota unlimited on ADMIN_INDEX;
> >
> > It said it cannot create becoz no ADMIN_DATA is exist, so I create this
> > tablespace by this statement:
> > create tablespace ADMIN_DATA datafile
> > '/export/home/oradata/db/admin_data01.dbf' size 1M;
> > But how to create a temporary tablespace TEMP_ADMIN? I cannot create it by
> > this:
> > create tablespace TEMP_ADMIN datafile
> > '/export/home/oradata/db/temp_admin01.dbf' size 1M temporary;
> >
> >
> > thx
>
> Thx, why not pull out the SQL manual and look up create tablespace?
>
> There are multiple ways to create a temporary tablespace depending on
> your version of Oracle. You first have to decide which kind you want.
>
> create temporary tablespace temp tempfile 'xxx' size n
> create tablespace temp temporary datafile 'xxx' size n
> create tablespace temp [permanent] datafile 'xxx' size n
>
> You need to see the manuals to determine which type is best for your
> situation.
>
> HTH -- Mark D Powell --
Received on Thu May 29 2003 - 05:06:05 CDT