| sqlloader problem- needed urgent [message #73101] |
Tue, 03 February 2004 00:15  |
Raja
Messages: 57
Registered: March 2000
|
Member |
|
|
Hello
I have a problem with sqlloader while loading data. here is the scenario
i want to load data into a table through sqlloader. suppose if i am trying to load 100 records and if any of the record fails to load, the data loading into the table should be aborted and no data should be loaded into the table. The data loaded into the table before sqlloader prg termination should also be deleted.
can anyone please help me out with an example. I need it urgently.
thanks in advance
raja.
|
|
|
|
| Re: sqlloader problem- needed urgent [message #73102 is a reply to message #73101] |
Tue, 03 February 2004 03:14  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
within sqlldr, i dont think you can do it.
a workaround would be.
1. take an export of target table.
2. truncate the records.
3. do the sqlload.
4. check the badfile for rejected records
5. if anything is found,
use sql to truncate the records inserted by sqlldr.
6. use imp to import the records back.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
