parallel extract

[Amos.Rosmarin]

Hi,

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

[ArndW]

Amos, might you redefine your table explicitly as {SchemaName}.dba_tab_subpartitions and try it again?

[Amos.Rosmarin]

Thanks, your the best

the job returns the expected rows but still I get this msg and the job finishes with status OK. I swore to you that the table (synonym) exists
(it's funny, the error msg is red but still the jobs finishes ok ... is it a good idea to suppress it from the log)

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

[roy]

Hi,
Did you rebuild the stages or simply added the schema prefix to the existing table name?
If you didn't rebuild the stage try it and see if the error persists.

IHTH,

[gssr]

Hi,
Did you rebuild the stages or simply added the schema prefix to the existing table name?
If you didn't rebuild the stage try it and see if the error persists.

IHTH,

Hi,
I am in the similar situation and tried the above solutions,
but still i am getting the error

Code: Select all

ORACLE_STAGING: GenericQuery:esqlErrorHandler
Prepare failed for: GenericStmt_1
sqlcode is: -942
esql complaint: ORA-00942: table or view does not exist

I can able to execute the same query in Sql Developer....

Any Ideas to resolve this...?

Thanks in advance.

[gssr]

More Information:
Oracle Enterprice Stage --> Dataset Stage

I just copied an excisting job and made some changes in it..
The Original Job is running fine!!

[ray.wurlod]

Presumably, then, the change(s) that you wrought is where you should be seeking a culprit.

Since you chose not to reveal what "some changes" involves, your question is in the class "my car won't start", and we prefer not to waste too much time guessing.

Tell us what you did and the exact text of any error message, and we may be able to respond cogently.

[gssr]

The Changes doesnot make any difference in the Query.....
I even tried the same query to run the new JOB, but still the error exists!!!

Any ideas??

[ray.wurlod]

If the one works, and the changed one does not work, then the change is the culprit.

[gssr]

I developed a new job with the same work flow and Query(Changed).
Now it work fine..

I could not get where is the actuall problem in the Copied Job,??

Any way the Problem is solved !