I am attempting to build an oracle datamart from the canvas data warehouse. We have create a database link form our oracle data warehouse to canvas/redshift data warehouse. I get errors when trying to insert data from canvas into oracle tables when the canvas data type is VARCHAR - evidently Oracle thinks the is a long data type and I am not able to convert it. Regardless of that data type i put in the oracle table i get the following error. ORA-00997: illegal use of LONG datatype. Please let me know if anyone has experienced this and/or has a resolution.