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..
11-25-2003, 02:56 AM
Have you indexed the columns you are connecting on?
11-25-2003, 10:23 AM
you're not getting stuck in some wierd recursive loop somewhere?
how big are the tables?
11-27-2003, 11:48 PM
Connect By Prior
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...
12-01-2003, 11:35 AM
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 ...