MelissaS
Active Member
We are using XE and have ERP 8 in testing. I want to copy all the secuirty information from XE to ERP 8. When I try to insert the F98OWSEC records from XE to ERP 8 by using INSERT INTO SYS7334.F98OWSEC SELECT * FROM SYS7333.F98OWSEC - I get the error ORA-00997: illegal use of LONG datatype. What is another way of doing this?? Thanks!