Skip to main content
Question

Swap Partitions in Vertica 7

  • May 26, 2017
  • 1 reply
  • 9 views
Swapna_1

I have swapped partitions between tables ( table1 and table2 ) using SWAP_PARTITIONS_BETWEEN_TABLES . If I want to undo this , can I re execute the swap partitions between the two tables again , so that the data will be in place as it was before swapping the partitions.

    1 reply

    Unknown
    • Unknown
    • New Participant
    • May 26, 2017

    Yes, assuming both tables still meet the criteria for swapping and no changes after the initial swap.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement