oracle--表空间操作

SQL> create temporary tablespace test_temp tempfile '/u01/app/oracle/oradata/oracle01/test_temp01.dbf'
  2  size 32m
  3  autoextend on
  4  next 32m maxsize 2048m
  5  extent management local;

主库查询结果
SQL>  select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/oracle01/temp01.dbf
/u01/app/oracle/oradata/oracle01/test_temp01.dbf

SQL>


备库查询结果

SQL>  select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/oracle01/temp01.dbf
/u01/app/oracle/oradata/oracle01/test_temp01.dbf

SQL>