Unexpected reasons for failure
Posted: Thu Aug 02, 2007 2:05 pm
I'm doing an initial load Here is what I have done.
Source has 18.6 million records.
Method 1 :
Job1 extract to file (success)
Job2 Load from file (Failed)
lots of warnings and rejects
Error message :Inserted value too large for column, row rejected.
ORA-01722: invalid number.
I used the same meta data information for the sequential file column definition as that of the target table.
I have no clue for the error.
Method 2:
Direct load from database to database.
No warnings or rejects.
Only concern is snapshot too old may occur.
Any suggestions.....
Source has 18.6 million records.
Method 1 :
Job1 extract to file (success)
Job2 Load from file (Failed)
lots of warnings and rejects
Error message :Inserted value too large for column, row rejected.
ORA-01722: invalid number.
I used the same meta data information for the sequential file column definition as that of the target table.
I have no clue for the error.
Method 2:
Direct load from database to database.
No warnings or rejects.
Only concern is snapshot too old may occur.
Any suggestions.....