Trying to archive atc/logging records from the base tables. The tables are in an Oracle 8.1.7 database. Running into issues on the atc_activation table, specifically the LONG RAW datatype for the “Event” field. Oracle does not support the copying of this datatype. One option available is the exporting then re-importing of the table structure along with the specified data, but this would require the existing tables to be dropped, then recreated. The production outage that this solution would require is something we’d like to avoid if possible.
Has anyone else run into this issue? If so, any ideas.
Thanks.