bulk insert & rebuild indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: bulk insert & rebuild indexes

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    bulk insert & rebuild indexes

    Hi All

    I have a table in db1 with 20 million records & 4 indexes.
    We are not using partioning.
    In db2 i have the same table with some additional columns .
    Now i want all the rows from table in db1 to table in db2
    along with the 4 indexes . after this i would be updating the
    new columns in db2.

    What would be the best approach . shall i go for sqlldr option

    Kindly give suggestions

    Regards
    Sushant

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Do an export from db1 and import into db2 with ignore=y.

    You could create the indexes fresh in db2 after the import.

    BTW, do not forget to analyze the schema.

    HTH.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    SQL*LOADER is faster than import, but the data should be in flat file.

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