Ok I have 2 tables in my oracle database - say TABLE 1 and TABLE 2.
They are exactly the same except TABLE 2 has 2 additional columns to TABLE 1.
I want to populate TABLE 2 with the data from TABLE 1.
I was trying to do it with this query:
INSERT INTO TABLE 2(SELECT * FROM TABLE 1);
However this is giving me an error: "ORA-00947: not enough values" because of the 2 additional columns in table 2. Anyone know a way around this?