The OFFLINE and NO_DROP keywords in the CASCADE clause for dropping partitions causes performance problems and is no longer supported.
You could use OFFLINE and NO_DROP keywords in the CASCADE clause to prevent partitions from being read or dropped.
OFFLINE and NO_DROP are not supported in the CASCADE clause.
Change applications to remove OFFLINE and NO_DROP from the CASCADE clause. Use an authorization scheme, such as Ranger, to prevent partitions from being dropped or read.