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

Table 14-6
dbdst_obj_move command options (continued)
DescriptionCommand option
Name of the partition which must be relocated.
More than one partition can co-exist in the same
tablespace.
-p partition name
Specifies the storage class to which the table or
index extents will be moved.
-c storage_class
Specifies the starting extent of the table or
index. The default starting extent is zero.
-s start_extent
Specifies the last extent of the table or index .
If this option is not specified, then the complete
table or index will be moved to target class.
-e end_extent
To relocate entire emp table to SYMMETRIX
1
Run the dbed_update command to make sure the repository is current.
2
Run the the following command:
$ /opt/VRTS/bin/dbdst_obj_move -S PROD -H /opt/oracle/home11g \
-t emp -c SYMMETRIX
To relocate extents 100 to 400 of table emp to SSD
1
Run the dbed_update command to make sure the repository is current.
2
Run the following command:
$ /opt/VRTS/bin/dbdst_obj_move -S PROD -H /opt/oracle/home11g \
-t emp -s 100 -e 400 -c SSD
To relocate and verify the relocation of partition q1_orders to SSD
1
Run the dbed_update command to make sure the repository is current.
2
Run the following command:
$ /opt/VRTS/bin/dbdst_obj_move -S PROD -H /opt/oracle/home11g \
-v -p q1_orders -c SSD
Configuring and administering SmartTier
Administering SmartTier at the sub-file level
268