Connect By Prior
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Connect By Prior

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    Question 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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you indexed the columns you are connecting on?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2002
    Posts
    80
    you're not getting stuck in some wierd recursive loop somewhere?

    how big are the tables?

  4. #4
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    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

  5. #5
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    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
  •  


Click Here to Expand Forum to Full Width