dbdst_partition_move - move a table partition to the desired storage class.
dbdst_partition_move -S ORACLE_SID -T table_name -p partition_name -c class
Veritas Storage Foundation. To determine whether this product is installed on a Linux system, enter:rpm -qa | grep VRTSdbed
The dbdst_partition_move command is used to move a table partition to the desired storage class. This command queries the database for the filenames used for the table partition, then perform a one time immediate relocation of the files involved to the desired storage class. In database, usually a table is owned by a user and multiple users can have same table. To uniquely identify the table_name, it is usually specified as <user>.<table>. If <user> is omitted, the the table_name is assumed to be owned by SYS.
The following options are supported:
-S ORACLE_SID Specifies the name of the Oracle database whose information will be retrieved. -T table_name Specifies the table name. The table should be a partition table and must be listed in all_tab_partitions. -p partition_name Specifies the partition name. This partition must be listed in all_tab_partitions. -c class Specifies the desired class where the tablespace should be moved to.
This command is supported in a RAC environment. This command can be run on any node of the RAC.
This example shows how to move SALES_Q1 partition of SALES table to storage class SLOW$ /opt/VRTS/bin/dbdst_partition_move -S PROD \
-T SALES -p SALES_Q1 -c SLOW
dbdst_partition_move must be run as Oracle DBA user. dbed_update must be run at least once before this command to ensure an up-to-date repository. dbdst_partition_move can not be executed when the database is down.
0 Command executed successfully. 1 An Error Occured. 101 Licence check failed. 102 No license to execute this command. 103 Invalid Storage Class 104 The device or mount point is not owned by user 105 Could not get information from Oracle Database 255 Could not load program.
RAC is not supported with some SF products/configurations. For details please refer to the Veritas Storage Foundation: Storage and Availability Management for Oracle Databases Guidedbdst_classify(1M), dbdst_admin(1M), dbdst_convert(1M), dbdst_file_move(1M), dbdst_partition_move(1M), dbdst_preset_policy(1M), dbdst_report(1M), dbdst_rmvol(1M), dbdst_show_fs(1M), dbdst_tbs_move(1M), dbdst_obj_move(1M), dbdst_obj_view(1M), oracle_edition(7)
Veritas Storage Foundation: Storage and Availability Management for Oracle Databases
SF for Oracle | dbdst_partition_move(1M) |