Convert LONG to VARCHAR - HELP!!
From: Place Your Full Name Here <yourlogin_at_ra.isisnet.com>
Date: Tue, 28 Feb 1995 14:53:57
Message-ID: <yourlogin.1.000EE69E_at_ra.isisnet.com>
Diane Johnston, City of Halifax, Halifax Nova Scotia, Canada ae522_at_cfn.cs.dal.ca Received on Tue Feb 28 1995 - 14:53:57 CET
Date: Tue, 28 Feb 1995 14:53:57
Message-ID: <yourlogin.1.000EE69E_at_ra.isisnet.com>
What I really needed to do was insert into a 'history' table from a current table (Version 7.0) and one of the fields is LONG and I get an illegal use of long data field. I think if I can convert the long field to varchar2, it will work. How do I convert ?
Tried: Dump table to ascii, modify row definition, use sql loader to reload and change data type BUT when I dump to an ascii file (using: spool filename, select * from tablename, spool off) it only dumps the first 80 characters of thelong field to the file!!!! Any other solutions? Please post or email ae522_at_cfn.cs.dal.ca
Diane Johnston, City of Halifax, Halifax Nova Scotia, Canada ae522_at_cfn.cs.dal.ca Received on Tue Feb 28 1995 - 14:53:57 CET