We have to read 2months of data (approximately 16 million records) from a table. For this we are using 8 Oracle Enterprise stages for faster retrieval and then using a funnel to merge it.
We were suggested to use the partition table clause instead of 8 oracle stages by Ascential guys.
However on using that we are getting the following error.
Code: Select all
##E TDOR 000299 23:04:42(001) <OrclBANK_CK_AUTH_FCT1>
APT_OracleRowid8PartTable: failed to get the block count.
The table in use is partitioned.
Any pointers to why this could be happening.