PROUTIL PARTITIONMANAGE COPY qualifier
- Last Updated:March 4, 2025
- 2 minute read
- OpenEdge
- Version 12.8
- Documentation
Partition management option to copy (restore) data into a partitioned table in the destination database from a temporary source database.
CAUTION: Both the source and target databases must be enabled and configured for
table partitioning. The source database must be in restricted mode for PARTITIONMANAGE COPY
to execute. See PROUTIL DBRESTRICT qualifier for details on restricting access to
your source database.
Syntax
|
Parameters
- db-name
- Specifies the table partitioned database where you are performing partition management. This is the destination database of the PARTITIONMANAGE COPY operation.
- source source-db
- Specifies the source database for the PARTITIONMANAGE COPY operation. The source database must be enabled for table partitioning.
- partition table-partition-name
- Specifies the partition name of the data to copy with the PARTITIONMANAGE COPY operation.
- composite initial table table-name
- Specifies that the composite initial partition of the table table-name is being copied by the PARTITIONMANAGE COPY operation.
- clear all
- Removes all partition copy pending state information from all
partitioned objects in db-name. The
clear all
option is only used if db-name needs to be used with prior versions of OpenEdge when a PARTITIONMANAGE COPY operation terminats prior to completion. - recs n
- Specifies the number of records to restore (copy) in a transaction. The default is 100.
PARTITIONMANAGE COPY copies data, local indexes, lobs and updates global indexes for the
specified partition in the destination database (db-name). The following conditions must be met before PARTITIONMANAGE COPY can
execute:
- The source and destination databases must have identical schema.
- The source database must be in partitioncopy restricted mode.
- Indexes (local and global) of the specified partition must be active. If any index is inactive, the utility exits with an error.
- The source and destination databases must be enabled for Table Partitioning.
If only destination (db-name) and
source (source
source-db) databases are specified on the command line,
PARTITIONMANAGE COPY invokes a menu-driven user interface as shown:
|
The user interface can be used to select multiple partitions to copy at once.
Notes
- PARTITIONMANAGE COPY can be performed when the database is online or offline.
- PARTITIONMANAGE COPY will not operate on read-only partitions.