00062.Oracle创建临时表空间

 

SQL> col filename for a30

SQL> col tablespace for a45

SQL> select f.name as filename,t.name as tablespace from v$tempfile f,v$tablespace t where f.ts#=t.ts#;

 

FILENAME                       TABLESPACE

------------------------------ ---------------------------------------------

/home/oracle/oracle/oradata/md TEMP

sp/temp01.dbf

SQL>  create temporary tablespace test_temp tempfile '/home/oracle/oracle/oradata/mdsp/test_temp.dbf' size 10m extent management local uniform size 1m;

 

Tablespace created.

SQL> col filename for a60

SQL> select f.name as filename,t.name as tablespace from v$tempfile f,v$tablespace t where f.ts#=t.ts#;

 

FILENAME                                                     TABLESPACE

------------------------------------------------------------ ---------------------------------------------

/home/oracle/oracle/oradata/mdsp/temp01.dbf                  TEMP

/home/oracle/oracle/oradata/mdsp/test_temp.dbf               TEST_TEMP