Skip data with column length greater than 255 during INSERT
746243Feb 3 2011 — edited Feb 3 2011Hello,
I have recently created a new table with a maximum column length of 255. I am attempting to insert data from an existing table into this new table but receive and ORA-12899 value too large for column error. Here is the syntax of my INSERT / table loading command:
INSERT INTO NEW_TABLE
SELECT * FROM OLD_TABLE
WHERE LENGTH(RESPONSE) <=255
ORDER BY REVERSE(NAME)
COMMIT;
I was under the impression that this SQL would only insert rows from the OLD_TABLE that were <= 255.
Any assistance would be greatly appreciated.
Thanks!
Scott