ERROR: Cannot create a distribution constraint on a non local table

Reason:

You attempted to create a distribution constraint using create_distribution_constraint() on a table but the named table does not have local scope

Resolution:

Ensure the table has local scope

Tips:

• Is the table name correct?
• Does the table name need to be qualified by a schema name?
• Use the star$tables view to find the name and scope of known tables