Re: export errors

> I don't see an NLS_ setting for the session character set.
> 
> No doubt Oracle is therefore groping in the dark wondering precisely
> whether you'd like your messages to appear in fluent Cantonese, or in
> pig Latin.
> 
> Try doing an: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
> 
> (or something similar) and see how you go.
> 
> Regards
> HJR
> 
> "Tom Sterin" <sterin_at_telocity.com> wrote in message
> news:3d610305_4_at_nopics.sjc...

I tried that earlier. It doesn't change the behavior. I also tried 2 other settings for NLS_LANG. Don't remember exactly what they were, but I believe it was the same with some letters lower-case and one with a different string at the end (following the .)

>> I am running Oracle 8.1.6 on RedHat Linux. When I try to do an export,
>> I get the following:
>>
>> /opt/app/oracle:> exp user/pass
>>
>> Message 206 not found; No message file for product=RDBMS, facility=EXP:
>> Release 8.1.6.1.0 - Production on Mon Aug 19 10:23:59 2002
>>
>> (c) Copyright 1999 Oracle Corpo
>>
>> Invalid format of Export utility name
>>
>> Verify that ORACLE_HOME is properly set
>>
>> Export terminated unsuccessfully
>>
>> EXP-00000: Message 0 not found; No message file for product=RDBMS,
>> facility=EXP
>>
>>
>>
>> I have seen many other postings with this same problem, and the common
>> answer is "check ORACLE_HOME". Here are the environment variables
>> which have all been exported:
>>
>> /opt/app/oracle/product/8.1.6/bin:> env | grep -i ora
>> PATH=/usr/local/bin:/usr/kerberos/bin:/bin:/usr/bin:/usr/local/bin:
>> /usr/bin/X11:/usr/X11R6/bin:/opt/app/oracle/product/8.1.6/bin:
>> /opt/jdk1.2.2/bin
>> ORACLE_BASE=/opt/app/oracle
>> ORACLE_HOME=/opt/app/oracle/product/8.1.6
>> ORACLE_BIN=/opt/app/oracle/product/8.1.6/bin ORACLE_SID=db2
>> LOGNAME=oracle
>> LD_LIBRARY_PATH=/usr/src/Mesa-3.0/lib:/opt/app/oracle/product/8.1.6/lib
>> HOME=/home/oracle
>> ORAENV_ASK=NO
>>
>>
>> The message file seems to be intact. I can look at the file or do
>> this:
>>
>> /opt/app/oracle/product/8.1.6/bin:> oerr exp 206 00206, 00000, "Export"
>> // UI[207,273]
>>
>>
>> I also get the "No message file" error for ORA errors. For example, in
>> sqlplus:
>>
>> SQL> select * from abc;
>> select * from abc
>> *
>> ERROR at line 1:
>> ORA-00942: Message 942 not found; No message file for product=RDBMS,
>> facility=ORA
>>
>>
>> and yet I can do this:
>>
>> /opt/app/oracle:> oerr ora 942
>> 00942, 00000, "table or view does not exist" // *Cause: // *Action:
>>
>>
>> Any thoughts? Thanks in advance.
>>
>> Tom
Received on Mon Aug 19 2002 - 15:09:41 CDT