export error in Oracle 10g

[rajeev kanta]

Hi,

I am a beginner in Oracle DBA. I was trying to export emp table of scott issuing the foll command:
exp system/manager file = scott.dmp log = scott.log table = scott.emp

My OS is windows.

When I executed this I got an error message saying:

SP2-0734 : unknown command beginning "exp sys/..." - rest of line ignored

Could anyone explain me as to why I am getting this error?

Thanks,
Rajeev

[PAVB]

You have not set your ORACLE_HOME properly, O/S doesn't know where exp program is... this is not an Oracle error but and O/S error message.

[ales]

Hi Rajeev,

Originally Posted by rajeev kanta

SP2-0734 : unknown command beginning "exp sys/..." - rest of line ignored

this is a sql*plus error message.

Exp is an os executable thus you should run it from windows command line.
Running exp from within sql*plus is possible but then you must put "host" or "$" at the start of line:

SQL>host exp system/manager file = scott.dmp log = scott.log table = scott.emp
LRM-00101: unknown parameter name 'table'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully


SQL>$ exp system/manager file = scott.dmp log = scott.log table = scott.emp
LRM-00101: unknown parameter name 'table'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

After running the exp you return to sql*plus with the "exit" command.

Also note that the "table" parameter is wrong, the correct syntax is "tables=...".

Your ORACLE_HOME is set OK as you were able to run sql*plus.

[rajeev kanta]

Hi

Thanks all for ur help.

Yeah as you(ales) said, I was executing this command at SQL prompt and so was getting this error msg. Now it's working when I executed it at command prompt.

But now I am facing another problem. I tried to exp a table of scott and then imported that as show below.

exp system/admin file = scott.dmp log = scott.log tables = scott.emp

imp system/admin file = scott.dmp fromuser = scott touser = ALLEN

Export and import terminated succesfully but when I checked for the exported table under tht user(allen), I could not find the table. I was getting the same msg as before saying table does not exist.

Where is the problem?

Thanks,
Rajeev

[davey23uk]

post the full logs