Swap Partitions in Vertica 7

Swapna_1Swapna_1
in General Discussion

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.

Answers

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...