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
3440 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

Explain temporal data types in oracle

1130

How to rename a column in an existing table?

1079

What are the types of partitions in oracle?

1076

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2314

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2595

What is a user account in oracle?

1163

What is the implicit cursor in oracle?

1165

How will you identify oracle database software release?

1052

What is archive log in Oracle?

1178

What's dateware house and what's clustor with practicle example

2231

What are the different types of database objects?

1110

Explain an index?

1179

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1888

Explain the use of indexes option in exp command.

1204

What is enter substitution variable in oracle?

1092