Oracle Error ORA-30399: a skip level must have at least one column that allows NULL values

Oracle Error Message

ORA-30399: a skip level must have at least one column that allows NULL values

Reason for the Error

A SKIP clause cannot be specified with a level when all of the columns that make up the level have NOT NULL constraints.

Solution

Drop the SKIP clause.