test veritas logo


dbdst_partition_move(1M)

NAME

dbdst_partition_move - move a table partition to the desired storage class.

SYNOPSIS

dbdst_partition_move -S ORACLE_SID -T table_name -p partition_name -c class

AVAILABILITY

Veritas Storage Foundation. To determine whether this product is installed on a Linux system, enter:

rpm -qa | grep VRTSdbed

DESCRIPTION

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.

OPTIONS

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.

Real Application Clusters (RAC) Considerations

This command is supported in a RAC environment. This command can be run on any node of the RAC.

EXAMPLES

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


NOTES

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.

EXIT STATUS

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.

SEE ALSO

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 Guide

dbdst_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)