Swap partition takes lock on source and target table?

Arvind_KumarArvind_Kumar Community Edition User

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 

Comments

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file