export error in Oracle 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: export error in Oracle 10g

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi Rajeev,

    Quote Originally Posted by rajeev kanta View Post
    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

  4. #4
    Join Date
    Mar 2009
    Posts
    4

    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post the full logs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width