News for hackers. Stuff that matters.
Re:Oracle’s Cloud Licensing Change by aNoob7000 on Monday January 30, 2017 @09:40AM (#13521502)
Sorry to break this to you but CLOBs and BLOBs are sort of a magical type field. They are a special kind of field that can hold up to something like a couple of gigs of characters or binary data in them. I'm not a PostgreSQL or MySQL admin but I would assume that you would have the same issues with those database pumping data in and out of CLOB/BLOB field type from database versions that don't match.

Based on what you were trying to do, maybe writing a simple program to read a record from schema A and insert it into schema B would have been easier and cost less.

Re:Oracle’s Cloud Licensing Change by bane on Monday January 30, 2017 @08:53PM (#13526820)
> Based on what you were trying to do, maybe writing a simple program to read a record from schema A and insert it into schema B would have been easier and cost less.

Yup, that's basically the lesson learned. Oracle's tooling is terrible, it's just easier to write your own most of the time.