Re: IDataReader.Read() throws Exception! How can i skip a row?
- From: "Patrice" <http://www.chez.com/scribe/>
- Date: Thu, 27 Nov 2008 18:56:24 +0100
What happens when using try/catch ? (if the stream doesn't recover from
this you can't perhaps not continue).
That said, my personal preference would be likely to report this to someone
that can fix this as working with a corrupted database is likely to cause
further problems (or avoid the row by not selecting this particular key for
now)....
Possibly point them to :
http://dbcrusade.blogspot.com/2008/08/oracle-resolving-ora-29275-partial.html
That seems to show how to fix the DB...
--
Patrice
"Venkat" <Venkat@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
groupe de discussion : 05BCB70A-1906-4490-AA9E-1BC73EAD364B@xxxxxxxxxxxxxxxx
Hello,
I am trying to do a simple dump of a huge table (~25 million rows) from
an Oracle database using Oracle Data Provider.Net.
I am calling ExecuteReader() on the Command object and then
DataReader.Read() in a loop.
Some where halfway through, an exception is thrown because of corrupt data
(ORA-29275: partial multibyte character)
I want to know if it is possible to skip this particular row and continue
with the rest of rows.
Other limitations:
1) I have only read permission on the target DB. So I cannot change
anything.
-Regards,
Venkat
.
- Follow-Ups:
- References:
- Prev by Date: Production statistics data storage
- Next by Date: Re: IDataReader.Read() throws Exception! How can i skip a row?
- Previous by thread: IDataReader.Read() throws Exception! How can i skip a row?
- Next by thread: Re: IDataReader.Read() throws Exception! How can i skip a row?
- Index(es):
Relevant Pages
|
Loading
