Re: export errors

I'm not really sure of the solution to your problem.

However, if you really want to do this export .. why don't you do it from a remote server where oracle exp is installed properly/settings are proper (i.e. if you have it .. same version exp)? It will run slow .. but hey .. at least you would be able to do it..

Anurag

"Tom Sterin" <sterin_at_telocity.com> wrote in message news:3d619aa9$1_1_at_nopics.sjc...
> On Mon, 19 Aug 2002 18:08:20 -0400, Sybrand Bakker wrote:
>
> > On Mon, 19 Aug 2002 17:42:49 -0400, Tom Sterin <sterin_at_telocity.com>
> > wrote:
> >
> >>On Mon, 19 Aug 2002 17:09:07 -0400, Sybrand Bakker wrote:
> >>
> >>> On Mon, 19 Aug 2002 16:09:41 -0400, Tom Sterin <sterin_at_telocity.com>
> >>> wrote:
> >>>
> >>>>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 .)
> >>>
> >>> add
> >>> export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> >>>
> >>> to your .profile
> >>>
> >>> Hth
> >>>
> >>>
> >>> Sybrand Bakker, Senior Oracle DBA
> >>>
> >>> To reply remove -verwijderdit from my e-mail address
> >>
> >>
> >>Still doesn't work. Adding the env variable didn't change the behavior.
> >>I tried it with and without the NLS_LANG variable set.
> >>
> >>Are the two problems (export and sqlplus not finding the message file)
> >>the same problem?
> >>
> >>Thanks.
> >>
> >>Tom
> >
> > they are.
> > please verify there is actually something in $ORA_NLS33 and you have the
> > <facility><language>.msb files installed ( you must have because oerr
> > works but anyway)
> >
> > Hth
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
> Yes, there are files named lx____.nlb in $ORA_NLS33
>
> /opt/app/oracle:> echo $ORA_NLS33
> /opt/app/oracle/product/8.1.6/ocommon/nls/admin/data
> /opt/app/oracle:> ls -1 $ORA_NLS33 | wc -l
> 453
> /opt/app/oracle:>
>
> I believe the .msb files you are asking about are in
> $ORACLE_HOME/rdbms/mesg. There are files including oraus.msb, oraus.msg,
> expus.msb, expus.msg, and others.
>
> Any other thoughts? Or could it be time to reinstall Oracle? I have the
> same problem in my applications but can work around them with oerr. But
> now I really need to do this export.
>
> Thanks.
Received on Mon Aug 19 2002 - 21:43:40 CDT