Importing 150,000 records - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Importing 150,000 records

  1. #21
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by hany
    yes i do, i will try that too, thanks Julian, i'll inform you if it works (or if it doesn't)
    You may want to not import the indexes but build them after the import. So disable the constraints, the triggers, INDEXES=N, IGNORE=Y, COMMIT=N, 1 big undo segment and let's hope for the best :-)

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  2. #22
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Take a look also at Metalink Note:93763.1.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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