-
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
-
export errors
Thanks, issue resolved i did export direct on NT and then ftp to unix
there were no errors in doing so.
Satish
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|