Hello there

I have database that i need to import data from one of the to the other.

I have in one of my tables 15000 records and one of them failed. and as a
result of that the entire proccess of importing the current table was
faliled.

Is there a way to import all the other records exept the records that
failed?

Set the max error count > 0 for the Data Pump task.
This is the number of errors the task can tolerate before aborting the
entire process.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote

Thanjes Darren.

But where can i find this option you have just said?

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Open the DataPump task properties dialog.
If using the Wizard, save the package first, then re-open to set this, then
save and execute.


"Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote