Copy one partition with the PARTITIONMANAGE COPY command line

To copy one partition with the PARTITIONMANAGE COPY command line, the syntax is as follows:

proutil target-database -C partitionmanage copy source source-database 
   { partition partition-name |
         composite initial table table-name }
     [ recs n]

For example, if you want to copy data to a production database named production_db, for the customer_a_llr_1 partition , and your source database is named temporary_db, enter the following command:

proutil production_db -C partitionmanage copy source temporary_db partition customer_a_llr_1

You can also copy a composite intial partition. For example, if you want to copy data to a production database named production_db, for the composite initial partition of the table customer, and your source database is named temporary_db, enter the following command:

proutil production_db -C partitionmanage copy source temporary_db composite initial table customer