DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: EXPORT

  1. 03-14-2002, 10:03 AM #1
    ndisang
    ndisang is offline Member
    Join Date
    Sep 2001
    Posts
    200
    I'm doing an export that it taking too long. It completes but it takes too long. What is happening? Apart from adding DIRECT=Y in my export script how do I make my export much faster.
    Thanks
    Life is what is happening today while you were planning tomorrow.
    Reply With Quote Reply With Quote
  2. 03-14-2002, 10:07 AM #2
    srlhome00
    srlhome00 is offline Member
    Join Date
    Oct 2001
    Posts
    126
    WHat is the whole export stmn you use?
    Try setting buffer to 5M.

    Susan
    Reply With Quote Reply With Quote
  3. 03-14-2002, 10:11 AM #3
    mike73
    mike73 is offline Senior Member
    Join Date
    Aug 2001
    Posts
    390
    By adding DIRECT=Y, you will not use the buffer so your export will run much faster and you import will run faster as well.

    no harm by using DIRECT=Y
    Reply With Quote Reply With Quote
  4. 03-14-2002, 10:15 AM #4
    srlhome00
    srlhome00 is offline Member
    Join Date
    Oct 2001
    Posts
    126
    Thank you fo rcorrecting me.

    Susan
    Reply With Quote Reply With Quote
  5. 03-14-2002, 10:42 AM #5
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    It also depends on the size of the database, the speed of the box it is on, disk contention, and the high tide in Singapore.

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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