Oracle Temp Table not getting Load ( Seems weird Issue)

[swades]

I am Straight Loading Temp Table from one Database to other.
I have created this Temp Table By : Generate DDL option.

When I am running the Job, Not a Single record getting Loaded.
I have set Update Action : Clear Table then Insert Rows.

What Strange here is : When I run the job with Limit of 1000 or 2000 rows, then those rows are get loaded.

Can any one have idea what can be cause of this ?

[ray.wurlod]

What is your Commit interval? For testing purposes, try running with rows per transaction and array size set to 1.

[swades]

Thank you very much Ray,

I have tried, thats working fine BUT job is running very slow.

Above (Earlier Post) behavior is not with other tables of Same Databse.

Thanks

[ray.wurlod]

Slow it may be, but suggests that the issue is with these settings. To what values were they set previously? Try increasing judiciously (from 1), making sure at all time that rows per transaction is a multiple of array size.

[swades]

Thanks Ray,

Previously transaction size was Zero.
But How rows gets loaded when I run job with Limit of 1000 or 3000 or 4000 rows ?

Thanks

[narasimha]

Previously transaction size was Zero.

Do you get any warnings/kickouts when you run it with the above settings?

[swades]

Do you get any warnings/kickouts when you run it with the above settings?

No

[ray.wurlod]

Probably 4000 rows finished quickly enough that there was no timeout before the COMMIT could be sent.