Swap partition takes lock on source and target table?

Arvind_KumarArvind_Kumar Community Edition User

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 


  • Options

    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file