ERROR: Distribution constraint already exists on table ...

Reason:

You attempted to create a distribution constraint using create_distribution_constraint() on a table but that table already has a distribution constraint

Resolution:

Ensure the table does not already have a distribution constraint

Tips:

  • Is the table name correct?
  • Does the table need to be qualified by a schema?
  • Use the star$tables view to find the name and scope of known tables
  • Use the star$constraints view to find the names of tables with distribution constraints
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk