While dropping a column on the table, got the below error.(ORA-12984)


oerr ora 12984

12984, 00000, “cannot drop partitioning column”
// *Cause: An attempt was made to drop a column used as the partitioning key.
// *Action: This action is not allowed.

We can’t drop the column in a partitioned table if that column is the partitioned key.

1. First, check whether the table is partitioned or not:

2. Find the partitioned key column

Here we can see the column CREATED is the partitioned key column, So oracle is not allowing us to drop that column.