Sanjay
i tried setting NLS_LANG on unix
as export NLS_LANG=american_america.WE8ISO8859P1
and tried export so still error message is
but i can do select * from that table for info
sqlplus sys/xxx@itb
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
With the Partitioning option
JServer Release 8.1.7.2.1 - Production

SQL> desc OTEN.SS_CATEGORY
Name Null? Type
----------------------------------------- -------- ----------------------------
CAT_ID NOT NULL NUMBER(2)
CAT_NAME VARCHAR2(50)

hduna1:/u01/app/oracle/admin/iced/scripts> echo $NLS_LANG
american_america.WE8ISO8859P1
hduna1:/u01/app/oracle/admin/iced/scripts> exp sys/smokinjoe@inet_itfwb3 file>

Export: Release 8.1.7.4.0 - Production on Thu Dec 5 15:01:49 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
With the Partitioning option
JServer Release 8.1.7.2.1 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Direct Path ...
Current user changed to OTEN
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

thanks

Satish