Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.
You want to change it to TableB
then use the following SQL.
CREATE TABLE TableB (NEW_COLUMN_1, NEW_COLUMN_2, NEW_COLUMN_3) AS SELECT (COLUMN_1,
COLUMN_2, COLUMN3) FROM TableA;
will have the new columns as expected.