OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » exp problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp problem [message #176522]

Thu, 08 June 2006 10:46

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

when i try to export data from db installed in unix box, I'm facing below mentioned error.

EXP-00094: Could not convert to server national character set's handle
EXP-00000: Export terminated unsuccessfully

Pls help me out to resolve the issue....

Naveen

Report message to a moderator

Re: exp problem [message #176523 is a reply to message #176522]

Thu, 08 June 2006 10:52

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Verify that LD_LIBRARY_PATH is set.

Report message to a moderator

Re: exp problem [message #176524 is a reply to message #176522]

Thu, 08 June 2006 10:55

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

can u pls tell me how to verify LD_LIBRARY_PATH... Its like a spoonfeeding... but i am new to this area....

Report message to a moderator

Re: exp problem [message #176534 is a reply to message #176524]

Thu, 08 June 2006 12:19

MatthewLange
Messages: 2
Registered: June 2006
Location: Ottawa, ON

Junior Member

Hi!

echo $LD_LIBRARY_PATH

Cool

Report message to a moderator

Re: exp problem [message #176535 is a reply to message #176524]

Thu, 08 June 2006 12:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

As the oracle user, to see if it's set:

echo $LD_LIBRARY_PATH

If it isn't set, then you can do the following:

Bourne, Bash, or Korn shell:
$ LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LD_LIBRARY_PATH

C shell:
% setenv LD_LIBRARY_PATH $ORACLE_HOME/lib

Report message to a moderator

Re: exp problem [message #176630 is a reply to message #176522]

Fri, 09 June 2006 00:43

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

Its showing

$ echo $LD_LIBRARY_PATH
/usr/lib:/opt/hpnpl/lib:/usr/dt/lib:/usr/openwin/lib:/usr/ccs/lib:/usr/ucblib:/o
pt/EMCpower/lib:/opt/VRTSvcs/EMC/lib:/apps/oracle/product/9.2.0/lib32:/opt/tools
/ldapsdk/lib

confused.....

Report message to a moderator

Re: exp problem [message #176724 is a reply to message #176630]

Fri, 09 June 2006 05:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

How many Oracle homes do you have on the box?

Report message to a moderator

Re: exp problem [message #176735 is a reply to message #176522]

Fri, 09 June 2006 06:19

lenakarthik
Messages: 2
Registered: January 2006
Location: Bangalore

Junior Member

Hi,

how to check with windows platform?

Regards
- karthik

Report message to a moderator

Re: exp problem [message #176753 is a reply to message #176735]

Fri, 09 June 2006 07:52

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Trick question...this parameter isn't used in Windows.

Report message to a moderator

Re: exp problem [message #176775 is a reply to message #176522]

Fri, 09 June 2006 09:23

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

i guess only one home.I dont have dba privilege...

Report message to a moderator

Re: exp problem [message #176848 is a reply to message #176775]

Sat, 10 June 2006 05:46

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How to check number of homes in MS Windows? Run the Registry Editor (Start - Run - regedit) and check "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE"; homes are listed in there.

Report message to a moderator

Previous Topic:	import using wild card?
Next Topic:	RMAN Backup jobs on 10g Release 2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 09 00:00:13 CDT 2026