Results 1 to 4 of 4

Thread: Is there any Issues in Oracle10g regarding UNION

  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Is there any Issues in Oracle10g regarding UNION

    When i tried with two select statements with One UNION, it is executing properly, when i'm adding one more UNION and select statement then it saying ORA-03113 error, Is there any issues regarding UNIon in Oracle10g

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you post your select statement, ORA-3113 is a communication error, does it happen every time you run this statement?

  3. #3
    Join Date
    Jan 2012
    Posts
    1
    http://oratips-ddf.blogspot.com/2008...ing-union.html

    That example was run in 10.2.0.3 and, as far as I know, two UNION statements won't throw an error. As mentioned before an ORA-03113 is a compmunication error.

  4. #4
    Join Date
    Feb 2012
    Posts
    3

    Arrow

    I use tons of unions and have never encountered this condition.
    More likely is that your database has a corruption which is unrecoverable (that will somtimes end the connection and result in an end of file on communication channel).
    Try to set you session in sql_trace, and execute the query again.
    Then investigate the alertlog and the logs generated since you enabled trace on your database. Probably you will find an error there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •