-
This is in conjunction to my y'day's query. I'm trying to do an insert to a table of about 50 million ows. How do I go about it.
It was just hanging last time I did, I have allocated a large rollback segment.
Basically I need to do a
insert into table emp1 as select * from emp;
How do I et commit for every 10000 rows.
Please help.
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
|