import is to much slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import is to much slow

  1. #1
    Join Date
    Nov 2000
    Posts
    33
    i am importing a single table of arround 30,0000 rows through imp
    and it is taking arround 6 hr. to complete.

    is there anyway to improve the speed ?


  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Talking

    May be you can try increasing the BUFFER Parameter in imp.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    any LOB's involved??

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Red face how you doing it?


    You doing it thru a GUI or thru command line?

    I have found command line to be much faster.

    - Magnus

  5. #5
    Join Date
    Feb 2001
    Posts
    389
    details of table needed and sga size needed.

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