Oracle does not have create or replace table oracle command. Create or replace is just valid for views, PLSQL: procedures only. You need to do the alteration using ALTER Table command only Or you can explicitly drop the table and create it again