ORA-49030
ONE ROW PER rows_per_option without IN clause but with multiple path patterns requires all path patterns to be named.
- rows_per_option: The rows per option (VERTEX or STEP).
Cause
ONE ROW PER VERTEX or STEP without the IN clause is being used for a query with one or more unnamed path patterns.
Action
Either remove ONE ROW PER VERTEX or STEP or add an IN clause or add a name to every path pattern.