Export error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Export error

  1. #1
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10

    Question 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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Change NLS_LANG at client to the same value as server.

    Sanjay

  3. #3
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10
    Sanjay
    i tried setting NLS_LANG on unix
    as export NLS_LANG=american_america.WE8ISO8859P1
    and tried export so still error message is

  4. #4
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10
    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

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  6. #6
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10

    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
  •  


Click Here to Expand Forum to Full Width