DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Load Problem

  1. #1
    Join Date
    Mar 2002

    Load Problem

    Hi all,

    i have to load a 3 Million rows from one Oracle table to another with
    transformation on it.
    During this process the temporay TBS growt indefinitly and CPU is 100%. This Load take many days but no row is loaded.
    I make a commit every 100 rows.

    Any Idea?

  2. #2
    Join Date
    Feb 2001
    How are you doing the Load?

  3. #3
    Join Date
    Mar 2002
    I use a ETL called Genio. It make a insert into ..select... with a internal commit;

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.