Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

To drop an existing temporary tablespace and recreate using Quick I/O files

Drop the temporary tablespace, including its contents:

$ sqlplus /nolog

SQL> connect / as sysdba;

SQL> drop tablespace tablespace_name including contents;

Create a Quick I/O file on a VxFS file system:

$ /opt/VRTS/bin/qiomkfile -h header_size -s size \

/mount_point/filename.dbf

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;

This example shows how 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' \

91Using Veritas Quick I/O

Handling Oracle temporary tablespaces and Quick I/O