Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export errors

Re: export errors

From: Tom Sterin <sterin_at_telocity.com>
Date: Tue, 20 Aug 2002 09:39:39 -0400
Message-ID: <3d6245ac$1_4@nopics.sjc>


On Mon, 19 Aug 2002 22:43:40 -0400, Anurag Varma wrote:

> 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
> 

Good idea. Unfortunately I have no other servers behind the firewall with Oracle installed.

> 
> "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 Tue Aug 20 2002 - 08:39:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US