Import is killing command prompt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import is killing command prompt

  1. #1
    Join Date
    Dec 2012
    Posts
    3

    Import is killing command prompt

    I am working on a database (9i) restoration which requires the use of the export/import utility. In my test environment everything works fine without issue. When I went to use the same import script in my production/live environment I can cut and paste the script into the command prompt and the table is imported correctly. But then I cannot cut and paste another script - the command prompt seems to freeze and the server needs to be restarted to be able to import another table. Has anyone had this issue???

    Any insight would be greatly appreciated.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,458

    Cool

    Quote Originally Posted by skirkpatrick View Post
    ... Etc ... But then I cannot cut and paste another script - the command prompt seems to freeze and the server needs to be restarted to be able to import another table. Has anyone had this issue???

    Any insight would be greatly appreciated.
    Due to the fact we cannot see what you are doing and our crystal ball is not working today, we can only speculate on the possibilities:

    1) Your cut and paste inserts CR (or LF) in wrapped lines causing a break where there should be none.
    2) Your script has quote(s) missing the(ir) closing pair.
    3) You execute an sql script that does not have "exit" command and it's waiting for input.
    4) Oracle rdbms does not like your data and cuts you off.
    5) Pick any other random reason.


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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