ORA-05055
cannot use predicate with specified pseudocolumn along with sharding key column predicates
Cause
Using predicates with pseudocolumns like ORA_SHARD_ID and ORA_SHARDSPACE_NAME are not allowed to be used along with predicates with sharding key columns
Action
Remove predicates with either the pseudocolumn or sharding key columns.