Re: Help with odd ORA 3113 Error

Try,

     ANALYZE TABLE VALIDATE STRUCTURE ...... Make sure that theres nothing wrong with your tables and index yet ...

I hope this helps

     joseph_sumalbag_at_bose.com

Joe Kaczor wrote:

> Hello All,
>
> We are currently running across an odd Oracle error/bug.
> We are attempting a simple SQL query, and are being
> disconnect from the database every time we attempt it.
>
> The code is as follows:
>
> select count(*)
> from table_a
> where usercode4 = 'DX'
> and usercode1 = 'ACTV'
> /
>
> From UNIX we get kicked back to the $ prompt, from SQL*Plus
> client side (Win 95) we get ORA-3113 enc of communication
> channel (which makes sense, since it is automatically disconnecting
> from the database)
>
> But if we try this :
>
> select count(*)
> from table_a
> where usercode4 = 'DM'
> and usercode1 = 'ACTV'
> /
>
> We get our results back OK. (DX and DM are both values
> in the usercode4 column).
>
> Has anyone ever seen this happen before? Any help
> is greatly appreciated.
>
> DB version 7.3.2.3
> DG Platform
>
> TIA,
> Joe
Received on Wed Apr 29 1998 - 00:00:00 CDT