Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-05052

In a Sharding Replication system, Barrier DDL on sharded table schema_name.table_name is not allowed directly on a shard from a session that has enabled shard DDL.
  • schema_name: The sharded table's schema name.
  • table_name: The sharded table's name.

Cause

In a Sharding Replication system, Barrier DDL directly issued on a shard from a session that has enabled shard DDL can lead to data or schema inconsistency and is not allowed.


Action

When running Sharding Replication, issue Barrier DDL on a sharded table from the catalog connection if you want to change the table schema or truncate the table.