Oracle DBA, How To, Error, Cause and Action

ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table


Cause:


STORE-IN (Tablespace list) clause was used while creating a local index on a range/list/composite range list partitioned table



Action:


Do not use the STORE_IN (Tablespace list) clause while creating a local index on range/list/composite range list partitioned table

No comments:

Post a Comment

Thanks for your comment.