AnsweredAssumed Answered

Using Oracle with redshift

Question asked by Lynn Cox on Sep 28, 2018
Latest reply on Sep 28, 2018 by fernerj@erau.edu

Hello,

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.

 

Thanks,

Lynn

Outcomes