Skip to main content

Swap partition takes lock on source and target table?

  • Nov 14, 2016 10:06 AM UTC
  • 1 reply
  • 12 views

Arvind_Kumar
Forum|alt.badge.img+1

SWAP_PARTITIONS_BETWEEN_TABLES (
'[[db-name.]schema.]staging-table',
'min_range_value',
'max_range_value',
'[[db-name.]schema.]target-table'
)
 
does Swap partition table function hold lock on source and target table when we run this function?
What are those locks?
 
I am using target table in select query at the same time when we run swap partition table function and i see data descripincies?
Any help 

1 reply

JingX
  • New Participant
  • Nov 17, 2016 9:51 PM UTC

Swap partition will take O lock on both source and target table since it changes data on both tables.