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

Thread: Improving the imp speed

  1. #11
    Join Date
    Jan 2002
    Posts
    113
    11 million rows shouldn't be such a problem. I would do a direct load through a db link. You can do this by using the APPEND hint. Here's how I would do this.

    1. Create the table (no indexes or primary key) with no rows in database B
    2. Create the db link in database B
    3. use an insert statement like this:
    insert /*+ APPEND */ into tableA (select * from tableA@databaseA);

    This will bybass the undo/redo writing. You'll be amazed at the load time. I use this all the time and load about 4 million rows in 20 seconds. Remember to build the indexes/primary key after you load the table.
    Arm yourself with knowledge

  2. #12
    Join Date
    Nov 2003
    Posts
    89
    insert /*+ APPEND */ into tableA (select * from tableA@databaseA);
    loads the data faster.
    I inserted 13 million rows under 3 minutes.

  3. #13
    Join Date
    Apr 2003
    Posts
    353
    with Nologging ..

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