sql statement for creating tablespace

From: myhome <myhome_at_home.hk>
Date: Tue, 20 May 2003 18:28:11 +0800
Message-ID: <3eca03a3@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 Received on Tue May 20 2003 - 05:28:11 CDT