-
export error in Oracle 10g
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
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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:
Code:
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.
Ales The whole difference between a little boy and an adult man is the price of toys
-
Export error
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.
Code:
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|