Home > Veritas Storage Foundation™ for Oracle Manual Pages

DBDST_TBS_MOVE (1)

User Commands

Table of contents


NAME

dbdst_tbs_move - move a tablespace to the desired storage class.

SYNOPSIS

dbdst_tbs_move -S ORACLE_SID -t tablespace_name -c class

AVAILABILITY

Veritas Storage Foundation for Oracle. To determine whether this product is installed on an \1 system, enter:

lslpp -L VRTSdbed


DESCRIPTION

The dbdst_tbs_move command is used to move a tablespace to the desired storage class. This command retrieves the repository for the filenames used for the tablespace, then perform a one time immediate move to the tablespace files.

OPTIONS

adminThe 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 tablespace_name
Specifies the tablespace name.
-c class
Specifies the desired class where the tablespace will reside.

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 EMP_INDEX tablespace to GOLD storage tier.


$ /opt/VRTS/bin/dbdst_tbs_move -S PROD -t EMP_INDEX -c GOLD

NOTES

dbdst_tbs_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_tbs_move can be executed when the database is down.


ENVIRONMENT

Please set LIBPATH to include /opt/VRTSdbms3/lib32


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

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.