Switch partition: NULL boundary id

• vpolasa

  Say Hey Kid

  Points: 685

  More actions

  January 5, 2026 at 12:35 am

  #4711711

  I have table: t1 in schema1 with 19 billion records. I have another table with same name: t1 in schema2. My goal is to move data from schema1 to schema2 and leave the empty table in schema 1. To achieve this, I'm using switch partitions.

  There are 30 boundary ids for the table schema1.t1 but also have 15 million records for boundary id: null.

  I'm able to switch partitions for all the boundary ids using below query:

  ALTER TABLE [schema1].t1 SWITCH PARTITION 1 TO [schema2].t1 PARTITION 1
  
  ..
  
  ALTER TABLE [schema1].t1 SWITCH PARTITION 30 TO [schema2].t1 PARTITION 30

  How can I switch partition for NULL boundary id?

  Thanks.