Deep Copy

After data is imported, you can perform a deep copy to modify a distribution key or partition key, change a row-store table to a column-store table, or add a partial cluster key. A deep copy re-creates a table and batch inserts data into the table.

GaussDB provides three deep copy methods.

• Performing a Deep Copy by Using the CREATE TABLE Statement
  
• Performing a Deep Copy by Using the CREATE TABLE LIKE Statement
  
• Performing a Deep Copy by Creating a Temporary Table and Truncating the Original Table