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
Swap partition takes lock on source and target table?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.