Cannot access partitioned tables in Oracle 8i Enterprise Sta
Posted: Thu Dec 16, 2004 12:14 am
This is a post on behalf of a friend:
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.
The table in use is partitioned.
Any pointers to why this could be happening.
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.