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