Hi,
I developed a job which had a source table and a view to fetch data from that source and to load that into a target table. View fetches about 250,000. But when it is loaded into target table it has some 1000(251,000) more records than view.
I'm facing this warning . ''OCI has fetched truncated data''.
Fatal error as ''ORA-01002: fetch out of sequence ''.
Also the table got locked initially followed by job lock. So i created a copy job and released the table lock and ran that and faced these errors finally.
Any idea why i faced this error?
Target table has more data than Source View
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
There might be two seperate issues you are facing.
There might be some column in the source which is having column length greater than the one in the target.''OCI has fetched truncated data''
I would recommend you to search the forum there had been few different scenarios for this issue.''ORA-01002: fetch out of sequence ''
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus