Re: Getting ora-3113 in 11.2.0.3 for table consists more columns

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 22 Aug 2012 21:23:38 -0300
Message-ID: <5035780A.9080600_at_gmail.com>

Add to that, hidden columns, such as those created in object types, are included in the count. For example, in the case of a table containing 'one spatial column', that column implies 7 hidden columns that do not appear in the normal column count.

(Not going to delve into the idea that more than 50 columns is often a symptom of bad design.)

However, that does not explain that this worked in an older version and no longer works in the new version.

Is there a mismatch between the client version (SQL*Plus, TNS/Oracle Networking, jdbc) and the database version?

/Hans

On 22/08/2012 8:55 PM, m.mudhalvan_at_aozorabank.co.jp wrote:
> Hi Prabhu
> Looks like limitations are 1000 columns. So please check on which
> SQL you are getting this error message
>
> http://docs.oracle.com/cd/E14072_01/server.112/e10820/limits001.htm
>
>
> Thanks & Regards
> Mudhalvan M.M
>
> Infrastructure Management Division
> Email m.mudhalvan_at_aozorabank.co.jp
>
>
>
> From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
> To: <oracle-l_at_freelists.org>
> Date: 08/23/2012 05:26 AM
> Subject: Getting ora-3113 in 11.2.0.3 for table consists more
> columns
> Sent by: oracle-l-bounce_at_freelists.org
>
>
>
> Lists
>
> We have upgraded a database from 11.2.0.2 to 11.2.0.3 last night. Post
> upgrade, we are getting ora-3113 error while running a query on the table
> which consists more than 550 columns and 750 columns.
>
> We are hitting a bug or this is known issue ? Any suggestions are highly
> appreciable.
>
> Thank you
> Prabhu
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 22 2012 - 19:23:38 CDT