Use bulk collect limit 5000 and forall with save exceptions and in exceptio

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

Question Posted / ana

1 Answers
3287 Views
MasterCard, I also Faced
E-Mail Answers

Answer Posted / ana

Use bulk collect limit 5000 and forall with save exceptions and in exception block rollback

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rename an index?

1011

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1816

What would you do with an in-doubt distributed transaction?

1926

Explain the difference between a procedure and a function?

1099

How to export data to a csv file?

1223

Why do we need oracle client?

897

What is dual table oracle?

932

How to omit columns with default values in insert statement in oracle?

1010

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2327

What are the restrictions in a oracle read only transaction?

981

What are the original export and import utilities?

1075

What is null value in oracle?

1048

how to join query for one source type is oracle another source type is sql server ?

2390

How to change user password in oracle?

981

definition of cluster and non-clustered index?

2971