Search International and National Patent Collections

1. (WO2017070234) CREATE TABLE FOR EXCHANGE

Pub. No.:    WO/2017/070234    International Application No.:    PCT/US2016/057745
Publication Date: Fri Apr 28 01:59:59 CEST 2017 International Filing Date: Thu Oct 20 01:59:59 CEST 2016
IPC: G06F 17/30
Applicants: ORACLE INTERNATIONAL CORPORATION
Inventors: BAER, Hermann
KUMAR, Ramesh
RAGHAVAN, Ananth
Title: CREATE TABLE FOR EXCHANGE
Abstract:
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.