Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

■ tablespace indicates which tablespace to move.
■ class indicates to which class the tablespace should be moved.
For example:
$ /opt/VRTS/bin/dbdst_tbs_move -S FLAS10r2 -t MYTBS -c MEDIUM
Assign placement policy file successful on filesystem /snap_data10r2
Begin enforcing filesystem /snap_data10r2 ...
Enforce placement policy successful on filesystem /snap_data10r2
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 P3 partition of the EMP1 table to storage class MEDIUM,
use the dbdst_partition_move as follows:
$ /opt/VRTS/bin/dbdst_partition_move -S FLAS10r2 -T EMP1 \
-p P3 -c MEDIUM
Assign placement policy file successful on filesystem /snap_data10r2
Begin enforcing filesystem /snap_data10r2 ...
Enforce placement policy successful on filesystem /snap_data10r2
Using Database Dynamic Storage Tiering
Dynamic Storage Tiering policy management
198