I try to do parallel extract from a table called RESOURCE in Oracle9 database.
By default the execution mode is sequential
If I add Partition Table = RESOURCE
I get the folowing error:
RESOURCE: GenericQuery:esqlErrorHandler
Prepare failed for: GenericStmt_11
query is: select count(*) from dba_tab_subpartitions where table_owner = upper('APPDB') and table_name = upper('RESOURCE')
sqlcode is: -942
esql complaint: ORA-00942: table or view does not exist
RESOURCE: APT_OracleRowid8PartTable: failed to get block count
RESOURCE: Errors encountered partitioning for table RESOURCE
RESOURCE: APT_OracleReadOperator: partitioning failed.
1. For partitioned tables we do not use subpartitions, it looks like PX requieres sub-partitions?
2. Why does it say dba_tab_subpartitions not found .... the table exists and the same query in sqlplus runs ok.
3. Can PX perform parallel query on a non partitioned table ?
Thnks,
Amos