Drop Partition Fails Generating ORA-00942 or ORA-02149 or ORA-14048

fact: Oracle Server - Enterprise Edition 8.1
fact: Oracle Server - Enterprise Edition 9
symptom: Cannot drop partition
symptom: ORA-02149: Specified partition does not exist
symptom: ORA-00942: table or view does not exist
symptom: ORA-14048: a partition maintenance operation may not be combined
with other
cause: Partition is created using a public or private synonym.
This is Bug 1716968 :CANNOT DROP PARTITION IF ADDED VIA SYNONYM - ORA-2149
base Bug 1273906 fixed in 9.0.2.



fix:

The strategy should be NOT to use synonyms (public nor private)
in any other statement then were the use of synonyms is supported.
Synonyms are only allowed for 5 DDL statements - AUDIT,
COMMENT, GRANT, NOAUDIT and REVOKE. However, the code does not apply these
restrictions but there are numerous places where this can cause problems,
as mentioned in duplicate bugs 648067, 754665 and 743026. Besides these 5,
the only other places where synonyms are ok within DDL is in the subquery
clause. Fixes will concentrate on preventing the possibility of creating
the partition using a public or private synonym.
.
Workaround:
Use a strategy where the partitions are added by
user having the private synonym created for adding the partition as:
SQL> alter table . add
partition ..;