Invention Grant
- Patent Title: Create table for exchange
-
Application No.: US15228831Application Date: 2016-08-04
-
Publication No.: US10657116B2Publication Date: 2020-05-19
- Inventor: Hermann Baer , Ramesh Kumar , Ananth Raghavan
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/22 ; G06F16/2455

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.
Public/Granted literature
- US20170109386A1 CREATE TABLE FOR EXCHANGE Public/Granted day:2017-04-20
Information query