DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Oct 2000
    what does the log file say ? did u check them for any errors ? I would also have a look at the parallel load.


  2. #12
    Join Date
    Apr 2001
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.