1 Reply Latest reply: Mar 28, 2014 1:43 PM by Gary Graham-Oracle RSS

    "Error signal in parallel query server"

    bac63623-3c3d-4fd4-bd73-f8970303f213

      Hi All,

      I want to run the below query but i got an error "Error signal in parallel query server".
      is this error appeared due to heavy data ? because i did not run another query at the same moment.

       

      Query:

       

      CREATE TABLE temp_Select_msite as

        (SELECT a."Site" AS "OuterSite",

            b."Market",

            b."Site",

            b."Cpg",

            b."Adg",

            b."KW ID",

            b.KW,

            b.MT,

            b."Imp",

            b."$Profit",

            b."$Cost",

            b."$Revenue",

            b."Bought Clicks",

            b."Sold Clicks"

          FROM TEMP_US_MOB b

          JOIN TEMP_US_MOB a

          ON (a."Site" != b."Site" and a."KW ID" != b."KW ID")

          );