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

Relocating tablespaces
Use the dbdst_tbs_move command to move tablespaces to the desired storage
class. The command queries the SFDB repository for the tablespace file names,
then performs a one-time move based on your immediate requirements.
To relocate a tablespace
◆
Use the dbdst_tbs_move command as follows:
$ /opt/VRTS/bin/dbdst_tbs_move -S $ORACLE_SID -t tablespace \
-c class
where
■ tablespace indicates which tablespace to move.
■ class indicates to which class the tablespace should be moved.
Relocating table partitions
Use the dbdst_partition_move to move table partitions. The command queries
the database to validate the names of the table and partition. From this
information, a list of datafiles is derived and a one-time move of the files to the
desired class is executed.
Before relocating a table partition, review the following information:
The database must be up when you run the dbdst_partition_move
command.
Prerequisites
To relocate a table partition
◆
Use the dbdst_partition_move command as follows:
$ /opt/VRTS/bin/dbdst_partition_move -S $ORACLE_SID -T table_name \
-p partition_name -c class
where
■ -T indicates the table name.
■ -p indicates the partition name.
■ -c indicates the class to which the table partition is to be moved.
For example, to move the SALES_Q1 partition of the SALES table to storage class
SLOW, use the dbdst_partition_move as follows:
$ /opt/VRTS/bin/dbdst_partition_move -S $ORACLE_SID -T SALES \
195Using Database Dynamic Storage Tiering
Dynamic Storage Tiering policy management