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

proutil db-name -C partitionmanage copy 
[ source source-db 
 [ partition table-partition-name | 
     composite initial table table-name ]
        [recs n] ] |
     clear all

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:

    
    Progress OpenEdge Partition Copy utility

    Source Database     : temp_source_db
    Destination Database: production_db

    1.	Copy Table instance by Partition
    2.	Quit

    Enter your selection:

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.