DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: fastest way to import

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    And I really tried not to show my bias.

    I think Windows NT is great for a Client OS and as a db server for small workgroup apps. In fact, I recommend NT for small shops all the time. When it comes to 1000 users and 2TB of data, no, that belongs on a unix box.
    Jeff Hunter

  2. #12
    Join Date
    Oct 2000
    Posts
    23
    Last time the import failed due to temp becoming full. I incresed the temp to 1.5gb and sga to 500mg(db buff alone is 250mb) and the table size is 3gb(30million rows)..
    export is going on since 1.5 hours or so..

    As well, on the other session i check dba_free_space for temp and still it is unused. it is as is..(1.5gb).. so where is it using temp ts and when??

    Any inputs ??

    thx

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    When indexes are created sorts are needed so temporary tablespace would be used

  4. #14
    Join Date
    Sep 2000
    Posts
    384
    Import with index=n ,buffer=the max possible,

    create the indexes by using the indexfile option.

    use alter session set sort_area_size= the max possible.

    create the temp tablespace with intial and next big sizes.

    run the index file ...

    everything will be fast.
    Radhakrishnan.M

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