perf. prob during load from sqlldr - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: perf. prob during load from sqlldr

  1. #11
    Join Date
    Oct 2000
    Posts
    467
    what does the log file say ? did u check them for any errors ? I would also have a look at the parallel load.

    Cheers
    Vinit

  2. #12
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    Disabling partitions of indexes using:

    alter index .. modify partition ... unusable;

    is a technique I've used reasonably successfully when loading partitions of large tables. You have to issue the command "alter session set skip_unusable_indexes=true" before you can insert into the table. I believe this can also be done from sqlloader - there is a control file parameter SKIP_UNUSABLE_INDEXES.

    The only problem is that you load into a table which has had a primary or unique key index disabled. It only works for ordinary indexes.

    If you're loading a partition from scratch, the better approach is generally to load a separate table with the same structure as the partitioned table and then swap the partition with the table.

    [Edited by nealh on 09-26-2001 at 04:47 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