DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rollback Problem

  1. #1
    Join Date
    Mar 2001
    Posts
    32
    SELECT LOADS FROM V$SQLAREA;
    :
    0604: error occurred at recursive SQL level 1
    1562: failed to extend rollback segment number 10
    1562: failed to extend rollback segment number 10


    Can someone explains about this?...

    thanks .

  2. #2
    Join Date
    Mar 2001
    Posts
    19

    PROBLEM WHEN USING JOINS [ NOT A REPLY TO THE ORIGINAL QUESTION!!! ]

    All,

    Please forgive me for posting my question as a reply to the one previously asked. Since i am very new to this forum i got struck with how to post a message to this list.

    I got a problem with my sql query can anyone please help me out

    Here is the description of all the 3 tables from where i am getting my data

    FIRS TABLE

    Name Null? Type
    ***************************************************FIR_ID NOT NULL NUMBER
    FIR_IDR NOT NULL VARCHAR2(4)
    WORLD_AREA_CD VARCHAR2(3)
    FIR_NAME NOT NULL VARCHAR2(25)

    FIRS_COUNTRY_CODES

    Name Null? Type
    ***************************************************

    FIR_COUNTRY_CODE_ID NOT NULL NUMBER
    FIR_ID NOT NULL NUMBER
    COUNTRY_CODE_ID NOT NULL NUMBER

    COUNTRIES TABLE
    ------------------

    Name Null? Type
    ***************************************************

    COUNTRY_ID NOT NULL NUMBER
    COUNTRY_ISO_CD VARCHAR2(2)
    COUNTRY_NAME VARCHAR2(25)


    when i execute this query it is working fine

    select FIR_ID from FIRS where FIR_IDR= 'FF' AND FIR_NAME= 'FIR' AND
    WORLD_AREA_CD= 'EXC'

    but when i execute this query

    Select c.FIR_ID from FIR_COUNTRY_CODES a, COUNTRIES b, FIRS c wh
    ere c.FIR_IDR= 'FF' AND c.FIR_NAME= 'FIR' AND c.WORLD_AREA_CD= 'EXC'

    can anyone please please explain me where i am going wrong.

    Please help guys,
    Seenu



  3. #3
    Join Date
    Feb 2001
    Posts
    123
    Looks to me like the second select statement is a cartesian product - there is no join linking the rows in FIR_COUNTRY_CODES with COUNTRIES or FIRS, so you will get a copy of all the rows in FIR_COUNTRY_CODES that match the selection criteria for each combination of rows in COUNTRIES and FIRS.

    Try the following where clause:

    where c.FIR_IDR= 'FF'
    AND c.FIR_NAME= 'FIR'
    AND c.WORLD_AREA_CD= 'EXC'
    AND c.FIR_IDR=a.FIR_ID
    AND c.FIR_COUNTRY_CODE_ID=b.COUNTRY_ID

    Assuming that the FIR_IDR field is a foreign key to the FIR_ID in the FIR_COUNTRY_CODES table, and that FIR_COUNTRY_CODE_ID refers to the COUNTRY_ID in the COUNTRIES table.

    HTH

    David.

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