Skip to main content
1 vote

TRUNCATE WITH PARTITION Constantly Fails on 1 Out of 620 Tables

As Dan Guzman mentioned, a truncate requires exclusive access to the entire table. It appears this is the case even when truncating a specific partition, as opposed to just requiring exclusive access ...
Ross Bush's user avatar
  • 557

Only top scored, non community-wiki answers of a minimum length are eligible