Swap partition takes lock on source and target table?
Arvind_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
0
Comments
Swap partition will take O lock on both source and target table since it changes data on both tables.