How to move from a LONG datatype in Oracle to a BLOB/CLOB?
Author: email@example.com (Knut)
We've got two issues here;
- UFORM et al have been created using the uf scripts and as such, the DDL is using a CLOB in the schema. However, our ASN file have had a "u4_compatibility" setting - thus, I would presume, limiting the amount of data stored in the CLOB. I'm stating this based on the fact that 1000+ of our forms have 'spilt' over into OUFORM. How can we export from UFORM/OUFORM and ensure all the data end up in the CLOB and not "reinserted" into the OUFORM table?
- We have other tables where the table was created using the LONG statement, and we'd like to switch over to a BLOB/CLOB structure. Given that we can export the data from these tables - the issue we have is that there will be records in the Otablename export. How do we ensure the records from the Otablename end up in the BLOB/CLOB and not in the Otablename if we export/import the data?