Trying to create an Explain Plan for an INSERT statement, one may see the error:
Error: "Operation aborted: MaxElementDepth constraint violated. Line: 1<PlanElement id = '674' operation="HASH JO.....
The error only occurs if INSERT statement has the /*+ parallel(auto) */ hint included in it. Here is the beginning of the statement:
INSERT /*+ parallel(auto) */
INTO <example_table> (<col_1>,
<col_2>,
<col_3>,
<col_4>,
The explain plan is generated without issues, if the hint is removed.
SQL Developer can generate the explain plan, without issue, with the hint in the statement.