Target table has more data than Source View

Sathishkumarins · Post by **Sathishkumarins** » Mon Nov 24, 2008 11:51 pm

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?

us1aslam1us · Post by **us1aslam1us** » Tue Nov 25, 2008 2:49 am

There might be two seperate issues you are facing.

''OCI has fetched truncated data''

There might be some column in the source which is having column length greater than the one in the target.

''ORA-01002: fetch out of sequence ''

I would recommend you to search the forum there had been few different scenarios for this issue.

Sathishkumarins · Post by **Sathishkumarins** » Tue Nov 25, 2008 3:00 am

Thanks. Will work on that.....