Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

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 table partitions, 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 storage_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 \
-p SALES_Q1 -c SLOW
Another example:
$ /opt/VRTS/bin/dbdst_partition_move -S VRTS11r2 -T EMP1 -p P3 \
-c MEDIUM
Assign placement policy file successful on filesystem /data11r2
Begin enforcing filesystem /data11r2 ...
Enforce placement policy successful on filesystem /data11r2
Using preset policies
Use the dbdst_preset_policy command to set a policy based on file name patterns
before the files are created.
Table 14-4 shows the preset policies command options.
257Configuring and administering SmartTier
SmartTier policy management