I'm having an issue in trying to import Remedy data directly into oracle using oracle's import utility.
Oracle 10gR2 on HPUX 11i. Back end db for Remedy Original db setup: Locale not set (default C) Oracle NLS_LANG american_america.we8iso8859p1 DB Char set - WE8ISO8859P1, National Char - AL16UTF16, nls_length_semantics - char We had a problem with french chars not being saved to db from client/web app. We could not change language sets as the program csscan had too many errors to do the change. So we created a dmp, dropped the db and recreated it with: At the OS level - set LANG and LC_ALL = en_US.UTF Oracle account NLS_LANG =american_america.we8iso8859p1 (unchanged) On db creation - char set = AL32UTF8, National Char = AL16UTF16 and nls_lenght_semantics=CHAR Ran the import on the dump but I'm getting the following errors on a few tables: . . importing table "T176" IMP-00058: ORACLE error 1461 encountered ORA-01461: can bind a LONG value only for insert into a LONG column IMP-00028: partial import of previous table rolled back: 139 rows rolled back The tables have a few columns of varchar2 (4000 char). I tried to change them to LONG but got the same error. Any help welcome. Kris Latter [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
