用这种方式 insert into t1(c1,c2,c3) select c1,c2,c3 from t2;
ORA-01036 illegal variable name/numberCause: Unable to find bind context on user side.Action: Make sure that the variable being bound is in the SQL statement.
如果目标表中的数据全部来源与源表的话,把目标表干掉(drop)重建,如下:create table tagert_tab tablespace tabspace_name as select * from splex;
insert into t1(c1,c2,c3) select c1,c2,c3 from t2;
as
select * from splex;