VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 3, Using VERITAS Quick I/O
Prerelease 8 September 2005, 8:54am Handling Oracle Temporary Tablespaces and Quick I/O
99
3. Create a new temporary tablespace using the create tablespace or create
temporary tablespace command.
To use the create tablespace command:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> create tablespace tablespace_name \
datafile '/mount_point/filename.dbf' \
size size reuse \
temporary;
To use the create temporary tablespace command:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> create temporary tablespace tablespace_name \
tempfile '/mount_point/new_filename.dbf' \
size size reuse;
Example
To drop tablespace tempts, create a Quick I/O file temp01.dbf, and then create a new
temporary tablespace tempts using the create tablespace command:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> drop tablespace tempts including contents;
Tablespace dropped.
$ /opt/VRTS/bin/qiomkfile -h 32k -s 100M /db01/temp01.dbf
$ sqlplus /nolog
SQL> connect / as dba;
SQL> create tablespace tempts \
datafile '/db01/temp01.dbf' \
size 100M reuse \
temporary;
Tablespace created.
Example
To drop tablespace tempts, create a Quick I/O file temp01.dbf, and then create a new
temporary tablespace tempts using the create temporary tablespace command:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> drop tablespace tempts including contents;
Tablespace dropped.
$ /opt/VRTS/bin/qiomkfile -h 32k -s 100M /db01/temp01.dbf
$ sqlplus /nolog