Oracle Solution for Error ora-30348
ORA-30348: ADD and DROP cannot both be specified
What triggered the Error:
One or more ADD clauses were found in the same ALTER DIMENSION statement with one or more DROP clauses.What should we do to fix it:
Separate your ADD operations into one ALTER DIMENSION statement and your DROP operations into another.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
