Export error

Database is on Win NT and from unix host using sql net i am trying to do export of a schema. I am getting following errors,
exp sys/xxx@abc file=exp.dmp owner=tempdba direct=y
Export: Release 8.1.7.4.0 - Production on Wed Dec 4 15:08:05 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
EXP-00041: Export done in server's WE8ISO8859P1, different from user's
character set US7ASCII
EXP-00000: Export terminated unsuccessfully

please help how can i resolve this error.

thanks

Satish

Change NLS_LANG at client to the same value as server.

Sanjay

Sanjay
i tried setting NLS_LANG on unix
as export NLS_LANG=american_america.WE8ISO8859P1
and tried export so still error message is

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

This error is different than what you were getting earlier. You might try running catexp again. Or also there are several bugs with 8.1.7.1/2 exports, fixed in 8.1.7.4

Sanjay

Thanks, issue resolved i did export direct on NT and then ftp to unix
there were no errors in doing so.


Satish