Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Relocating table partitions for Database Dynamic Storage Tiering using
dbdst_partition_move
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 preset policies for Database Dynamic Storage Tiering using
dbdst_preset_policy
Use the dbdst_preset_policy command to set a policy based on file name patterns
before the files are created.
Use the dbdst_preset_policy command as follows:
$ /opt/VRTS/bin/dbdst_preset_policy -S $ORACLE_SID -d directory \
-P pattern_spec
Veritas Storage Foundation for Oracle Command Line Interface
About the command line interface
388