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 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 - 14:42:29 CDT