2 Replies Latest reply on Aug 6, 2019 6:34 AM by 3176985

    Query Returns ORA-01427: single-row subquery returns more than one row when XMLIndex is Present

    3176985

      Hi ,

       

      I have created a one row one column table of xmltype

      I loaded xml file into xmltype table using sqlldr , before fetching data I applied index(xdb.xmlindex).

      After applying index, select query is working properly for small XML but if xml size is in GB , I am getting an error (ORA-01427: single-row subquery returns more than one row ).

      Without applying Index, data fetching is very slow, I tried with both Direct path loading and ref cursor with Bulk insert but performance is still slow.

       

      Kindly suggest.

       

      Regards,

      Adil