Results 1 to 3 of 3

Thread: slow export

  1. #1
    Join Date
    May 2003
    Location
    Iran
    Posts
    3

    Post Unanswered: slow export

    I can a problem with export data from personal oracle 8i (8.1.5) it is very slow .

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    which parameter do you use for exp?

    possibly you can use direct=y recordlength=65000 or a large buffer

    but unfortumately there is a possible bug the the direct options that corrupt the expfile. It occurs if you have larger tables (>1.8GB) and/or lob objects

  3. #3
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    maybe use a larger buffer
    exp buffer=100000000
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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