"StephenP" <StephenP@discussions.microsoft.com> wrote in message
news:D1AE990D-2379-4CAB-A5A8-637041A1D770@microsoft.com...
> What I have been noticing is when you move a single table (around 250000
> records), it works without any errors. If you move that same table with a
> few other tables (around 250000 records), the same error occurs. It seems
> to
> prefer tables no larger than 250000 records. Any multiple table exports
> or a
> single table larger than 250000, it will cause an error.
>
> "Alex" wrote:
>
>> Oracle does not null values very much
>> check the value in (key) columns in row # 212101
>> "StephenP" <StephenP@discussions.microsoft.com> wrote in message
>> news:98669A8D-605E-437C-8409-81D2E63F6151@microsoft.com...
>> >I have been having problems copying very large table (500,000 records or
>> > more) from a SQL Server 2000 database to a Oracle 9i database. I have
>> > been
>> > using DTS wizard to design a very simple data export. The DTS starts
>> > out
>> > working fine but usually after 200,000 records, I will receive this
>> > error:
>> >
>> > error at destination for row number 212101. errors encountered so far
>> > in
>> > this task: 1.
>> > row-00060: internal error: [dainsert,16]
>> >
>> > I am not sure what is causing the error. Does anyone know what the
>> > problem
>> > is and how to resolve it? If there is a better method to export the
>> > data,
>> > please let me know. Thanks.
>> >
>> > Stephen
>>
>>
>>