How to fix the Oracle error ORA-30348: ADD and DROP cannot both be specified?

In this post, you’ll learn more about the Oracle ErrorORA-30348: ADD and DROP cannot both be specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-30348: ADD and DROP cannot both be specified

Reason for the Error ORA-30348: ADD and DROP cannot both be specified

One or more ADD clauses were found in the same ALTER DIMENSION statement with one or more DROP clauses.

How to fix the Error ORA-30348: ADD and DROP cannot both be specified ?

You can fix this error in Oracle by following the below steps

Separate your ADD operations into one ALTER DIMENSION statement and your DROP operations into another.