Quote Originally Posted by hrishy
Hi

No sql is atomic its all or none.
You need to use pl/sql for that use bulk collect and fetch 1000 rows at a time and commit

regards
Hrishy
there is a little mistake, this is DDL, need not commit command.
hehe