-
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?
Thank's
-
How are you doing the Load?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|