insert into table1(COL1,COL2,COL3,COL4)
select col1,col2,col3,col4 from table2
insert into table FINAL (select * from STAGING)
updated on 26-Jul-2015:
If you get error like "ORA-12899: value too large for column emp_name (actual: 16, maximum: 15)" while inserting or updating data from one table to another, and if you have also tried LENGTH function, then there is something more to look into.
The usual reason for problems like this are non-ASCII characters that can be represented with one byte in the original database but require two (or more) bytes in the target database (due to different NLS settings).
Try below query to find out the reason:
SELECT * FROM staging WHERE lengthb(mycol) > 15
select col1,col2,col3,col4 from table2
insert into table FINAL (select * from STAGING)
updated on 26-Jul-2015:
If you get error like "ORA-12899: value too large for column emp_name (actual: 16, maximum: 15)" while inserting or updating data from one table to another, and if you have also tried LENGTH function, then there is something more to look into.
The usual reason for problems like this are non-ASCII characters that can be represented with one byte in the original database but require two (or more) bytes in the target database (due to different NLS settings).
Try below query to find out the reason:
SELECT * FROM staging WHERE lengthb(mycol) > 15
No comments:
Post a Comment