SQL & PL/SQL

Hello everyone.

I am trying to create a table as the following.

CREATE TABLE new_table

            AS (SELECT  ID_FECHA_HIST AS DATE,

            ID_STATUS AS VARCHAR2(1),

            ID_FINMES AS NUMBER(1), ot.* FROM old_table ot);

But it does not seem to work. I have a cursor that containts the select ot.* from old_table ot statement and other statements like that, but in my new tables I want three extra fields that in the current table these new fields does not exists. I tried to do an alter statement later but I can not reorder the columns, and I need that the three new columns stays in the firsts positions.

Could you help me please?

Thank you.