| Rollback [message #71870] |
Thu, 23 January 2003 11:20  |
Sirisha
Messages: 7
Registered: May 2002
|
Junior Member |
|
|
Hey all,
is there any way to rollback the transactions that were inserted using SQLLoader.For ex..the data file is containing 1000 rows,but due to some problem.10 rows were rejected..i want whole whole transaction should roll back..means...either all the 1000 rows should inserted or none should be inserted....
Thanks and Regards
SirishaR
|
|
|
|
| Re: Rollback [message #71872 is a reply to message #71870] |
Thu, 23 January 2003 12:43  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I beleieve, there is no transcation control with sql*loader.
a workaround would be setting
ERRORS=0
so that NO ERRORS are allowed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
