OneWorld/Oracle Question

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!
 
You may want to try using an Oracle Export to export from the SYS7333 tablespace, and then use an Oracle Import to import it into SYS7334 tablespace.
 
Don't remember the Oracle syntax, but I believe you need to use the VarChar.
 
The syntax is right. BUT you can copy the tables with long type column using this syntax

Try copy .. append command from sqlplus
e.g
copy from user/password@abc to user/password@xyz
append target_table using select * from source_table;

Hope this help
 
Hello, Melissa,
Use table export/import. If you need the syntax, let me know.
Are these two tables identical?

Regards, Alex Shevchenko

XE SP18 Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test
 
Thanks for the suggestion. This acutally worked to move the data but for some reason JDE didn't like it and when I tried to log in - told me that the accounts had been disable. But thanks for the suggestion because I have found other uses for COPY. Thanks!
 
Back
Top