Home » RDBMS Server » Backup & Recovery » exp problem
exp problem [message #176522] Thu, 08 June 2006 10:46 Go to next message
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
Re: exp problem [message #176523 is a reply to message #176522] Thu, 08 June 2006 10:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Verify that LD_LIBRARY_PATH is set.
Re: exp problem [message #176524 is a reply to message #176522] Thu, 08 June 2006 10:55 Go to previous messageGo to next message
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....
Re: exp problem [message #176534 is a reply to message #176524] Thu, 08 June 2006 12:19 Go to previous messageGo to next message
MatthewLange
Messages: 2
Registered: June 2006
Location: Ottawa, ON
Junior Member
Hi!

echo $LD_LIBRARY_PATH

Cool
Re: exp problem [message #176535 is a reply to message #176524] Thu, 08 June 2006 12:20 Go to previous messageGo to next message
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
Re: exp problem [message #176630 is a reply to message #176522] Fri, 09 June 2006 00:43 Go to previous messageGo to next message
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.....
Re: exp problem [message #176724 is a reply to message #176630] Fri, 09 June 2006 05:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How many Oracle homes do you have on the box?
Re: exp problem [message #176735 is a reply to message #176522] Fri, 09 June 2006 06:19 Go to previous messageGo to next message
lenakarthik
Messages: 2
Registered: January 2006
Location: Bangalore
Junior Member
Hi,

how to check with windows platform?

Regards
- karthik
Re: exp problem [message #176753 is a reply to message #176735] Fri, 09 June 2006 07:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Trick question...this parameter isn't used in Windows.
Re: exp problem [message #176775 is a reply to message #176522] Fri, 09 June 2006 09:23 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

i guess only one home.I dont have dba privilege...
Re: exp problem [message #176848 is a reply to message #176775] Sat, 10 June 2006 05:46 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: import using wild card?
Next Topic: RMAN Backup jobs on 10g Release 2
Goto Forum:
  


Current Time: Fri Mar 29 10:24:24 CDT 2024