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

Thread: Import takes long time

Threaded View

  1. #10
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    you can go for datapump...if you are using the oracle10g.

    Other wise you can follow this steps as the above person said

    COMMIT=Y
    BUFFER=12000000
    just like commit=y you can use nolog=y
    direct=y

    or

    you can use incremental export

    at the time of exporting you can export the indexes in to another file...
    you can get lot of solution in the Google.... :-)
    Last edited by gopu_g; 04-03-2008 at 05:45 AM.

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