Printable View
I have Oracle 9i client version installed on my machine and am not able to do exp/imp. I get " 'exp' is not recognized as an internal or external command" from my command prompt. I am running on Windows XP2002. Is there anything in the config I can change or do I have to re-install Oracle again.
Thanks.
Have'nt you installed the server version?
Can you locate exp.exe in bin?
it depends on the client you have installed, if it is light client then you wont be able to do it.
Then run the catexp.sql or catalog.sql script
I have the client version installed and am not able to locate exp.exe. Will try installing the server version.Quote:
Originally Posted by dbasan
Cllient -standard- installation should be enough
Look under ORACLE_HOME/bin
also try running the exp/imp by specifying the full path to the executable. if %ORACLE%\bin is no in your PATH then just tying exp/imp is not good enough
how can it be the only issue? He has already said it isnt installed!!Quote:
Originally Posted by jagsy
Is there anywhere I can download just the imp/exp utility or similar tools ? I have 9i client installed, but need the tools to export/import some data.
You can get the executable from another XP systems you have, provide they are the same Oracle version or higher.
If this is for your personal use then you can download from Oracle.
All the best! :)
I got the executabels from a different computer with the same Oracle and OS version as mine. When I try to run the exp, this is what I see : Any ideas ?
Code:H:\SR\deployment_scripts\SR_4_1>exp
Message 206 not found; No message file for product=RDBMS, facility=EXP: Release
9.2.0.1.0 - Production on Tue Jul 31 10:41:42 2007
Copyright (c) 1982, 2002, Oracl
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
H:\SR\deployment_scripts\SR_4_1>path
PATH=C:\oracle\ora92\bin;C:\oracle\ora921\bin;C:\Program Files\Oracle\jre\1.3.1\
bin\;C:\Program Files\Oracle\jre\1.1.8\bin\;C:\WINDOWS\system32;C:\Program Files
\Java\jdk1.5.0_09\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:
\Program Files\QuickTime\QTSystem\;C:\Program Files\SecureCRT\;C:\Program Files\
Rational\common;C:\Program Files\Rational\ClearCase\bin
Did you check your ORACLE_HOME? is it properly set?
ORACLE_HOME is set properly. I looked in the PATH command and also in regedit.
Did you ever type something like...
set ORACLE_HOME=c:\oracle10g or whatever is your home and,
set ORACLE_SID=yoursid
...before trying to invoke exp?
ORACLE_HOME is properly set.
Code:H:\SR\deployment_scripts\SR_4_1>echo %oracle_home%
c:\oracle\ora92
Can you set these again and take the exp in command prompt:Quote:
Originally Posted by rshivagami
> ORACLE_HOME
> ORACLE_SID
I set it again in DOS prompt.
Still no improvement.Code:C:\Documents and Settings\sramasamy>cd ..
C:\Documents and Settings>set oracle_home=c:\oracle\ora92
C:\Documents and Settings>echo %oracle_home%
c:\oracle\ora92
C:\Documents and Settings>set oracle_sid = orcl
C:\Documents and Settings>exp
Message 206 not found; No message file for product=RDBMS, facility=EXP: Release
9.2.0.1.0 - Production on Tue Jul 31 14:20:35 2007
Copyright (c) 1982, 2002, Oracl
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
C:\Documents and Settings>
Yes, You have not set the sid properly, can you echo oracle_sidQuote:
Originally Posted by rshivagami
set oracle_sid=orcl (remove spaces before and after =)
echo %oracle_sid%
you cant just copy executables, you need to install as you will get all the dependancies then
How do I install just the executables ? The universal installer does not provide that option.Quote:
Originally Posted by davey23uk
yes it does - either choose administrator or custom