Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBDST_PARTITION_MOVE (1M) |
|
Maintenance Commands |
Table of contents
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 for Oracle.
To determine whether this product is installed on a Solaris system, enter:
pkginfo -l 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:
-
.\" $Id: dbdst_options.inc,v 1.1 2006/02/16 01:33:08 susanl Exp $
-
-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 example shows how to move SALES_Q1 partition of SALES table to storage class SLOW
$ /opt/VRTSdbcom/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.
Please set LD_LIBRARY_PATH to include /opt/VRTSdbms3/lib32
-
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.
dbdst_classify(1M),
dbdst_admin(1M),
dbdst_convert(1M),
dbdst_file_move(1M),
dbdst_fstat(1M),
dbdst_makelbfs(1M),
dbdst_partition_move(1M),
dbdst_preset_policy(1M),
dbdst_report(1M),
dbdst_rmvol(1M),
dbdst_show_fs(1M),
dbdst_addvol(1M),
oracle_edition(7)
Veritas Storage Foundation for Oracle Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.