CREATE TABLE FOR EXCHANGE

摘要

Techniques are described herein for creating a new database table for an exchange operation with a table partition of another table. A database management system (DBMS) is configured to receive a query such as “CREATE TABLE new_table FOR EXCHANGE FROM partition_P1”. The DBMS then identifies properties of the source partition (e.g., partition P1) and creates a new database table based on the properties identified. Some of these properties (e.g., hidden columns, data modeling frameworks, and table statistics) may not otherwise be directly accessible by the external entity that sent the query. The newly created table then has all of the necessary properties to be part of the other table if swapped with the source partition in an exchange operation.

主权项

1. A method comprising:
receiving a DDL statement referring to a first database table and specifying to create a table for an exchange with at least a portion of the first database table; in response to receiving said DDL statement, creating a second database table having one or more physical properties of said first database table; wherein said one or more physical properties includes at least one of the following particular physical properties:
a physical column order of data blocks of said first database table, anda position within a data block for a column truncated from said first database table.