Stepwise-Lab

ORA-01439: Column to be modified must be empty to change data type

ALTER TABLE ... MODIFY to another data type family works only when the column has no values.

On the exam

This error belongs to the topic Tables and constraints of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors