Skip to main content

Swap partition takes lock on source and target table?

  • November 14, 2016
  • 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
  • November 17, 2016

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