Is exp an Unix command?

gopikrish · 12-12-2004, 09:33 AM

Is exp an Unix command or Oracle command?

For eg,
exp userid/password file=/dev/rmt0 table=emp volsize=1.2G

In the above, is it an Oracle Sql Plus statement or Unix command?

And I guess "export" is an Unix command ?
For eg,
export ORACLE_SID=$DB

Full coding is in page http://www.orafaq.com/faqunix.htm
if you can't understand my partial commands I have posted.
Thanks.

trickykid · 12-12-2004, 09:56 AM

Are you going to keep asking the same questions, just different values in the commands your asking:

http://www.linuxquestions.org/questi...hreadid=265278

I think my other reply answered this question as well.

gopikrish · 12-12-2004, 10:20 AM

No I asked both "exp" command and "export" command.
So export is same as what I asked yesterday but exp command is different. I think its sqlplus tool. Am I right? Thanks.

paulsm4 · 12-12-2004, 11:41 PM

Hi -

You're absolutely correct, gopikrish. "exp" is an Oracle command (for "exporting" an Oracle table or tables). "imp" is the inverse, for importing back into Oracle. And neither command has anything to do with the shell command "export".

'Hope that helps .. PSM

scuzzman · 12-13-2004, 01:19 AM

Just as as added tidbit
export is not a UNIX command either - it's a Bash command. Might I reccomend a quick look at both the Oracle docs and Bash docs, as they might prove to be useful reading...