Connect By Prior

Hi,
Can anyone help me to resolve the following issue?.

I am using the CONNECT BY PRIOR Clause in my Query. But i am getting resluts after atleast 10 min in the SQL Prompt..

When i am tring to execute my procedure for 5 lakhs records Many times i am getting the error as ERROR: -- ORA-30928: Connect by filtering phase runs out of temp tablespace... evethough We are having 8 GB as Temp tablespace..

Have you indexed the columns you are connecting on?

you're not getting stuck in some wierd recursive loop somewhere?

how big are the tables?

Thanks for your response.

Yes, I checked against with index, and also with out index too...
My source table having 18 lakhs records with 8 fields ... row size as 4589 Bytes...

Any clue?

Look at your size limitations on the TEMP tablespace ...
Initial and Next (should be the size of sort_area_size)...
also look at the max_extents ...

HTH
Gregg