-
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..
RP Kumar
You Can Win, if u believe Yourself
-
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?
-
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...
Any clue?
RP Kumar
You Can Win, if u believe Yourself
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|