Partition Move Results in ORA-00001 Unique Constraint Error on SYS.I_WRI$_OPTSTAT_SYNOPHEAD (Doc ID 2775740.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• ORA-00001 error when trying to move a partition:
  
  ALTER TABLE dw_admin.fact_table
  MOVE PARTITION sys_p71000
  ONLINE TABLESPACE users
  COMPRESS FOR QUERY LOW
  PCTFREE 5;

  ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_SYNOPHEAD) violated

   

Changes

 None.  This type of partition move has worked error-free in the past.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.