Progress
Database Administration
Guide and Reference


PROUTIL TABLEMOVE Qualifier

Moves a table and optionally its associated indexes from one storage area to another while the database remains online.

NOTE: The _UserStatus virtual system table displays the utility’s progress. For more information see Maintaining Database Structure."

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C tablemove
[owner-name.]table-name table-area [index-area]

db-name

Specifies the name of the database containing the table.

owner-name

Specifies the owner of the table containing the data you want to dump. You must specify an owner name unless the table’s name is unique within the database, or the table is owned by “PUB.” By default, Progress 4GL tables are owned by PUB.

table-name

Specifies the name of the table to be moved.

table-area

Specifies the area name of the target application data area into which the table is to be moved. Area names with spaces in the name must be quoted, for example, “Area Name.”

index-area

Optionally, specifies the name of the target index area. If the target index area is supplied, the indexes will be moved to that area. Otherwise they will be left in their existing location. You can move indexes to an area other than the area to which the table is being moved. Area names with spaces in the name must be quoted, for example, “Area Name”.

NOTES


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095