Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-03927

invalid use of STORE IN clause for a sharded table or index

Cause

The STORE IN (tablespace list) clause was used to specify tablespaces for partitions of a sharded table or for partitions of an index where the sharded table did not have subpartitions or the subpartition method was not hash.


Action

Use the TABLESPACE SET clause or SUBPARTITION TEMPLATE clause to specify tablespaces for table and index partitions or table subpartitions, respectively.