ORA-03113 means your session and the server process have stopped talking. This shouldn't happen in your situation. Of course if you have further complications (like it's not a table but a complex view, or there's a VPD function or....) then there maybe a specifc bug/issue that you hit. In either case the trace files mentioned earlier should give you more info On Tue, Mar 22, 2011 at 11:08 AM, jo <jose.soares@xxxxxxxxxxxxxx> wrote: > Hi all, > > Does someone know what this error mean? > "end-of-file on communication channel" > > I have the following table, with no rows stored: > > name | data_type | nullable | data_default | data_length > --------------- + --------- + -------- + ------------- + ----------- > COD_MALATTIA | NVARCHAR2 | Y | NULL | 20 > COD_MATRICE | NVARCHAR2 | Y | NULL | 20 > COD_NAZIONE | NVARCHAR2 | Y | NULL | 6 > DATA_FINE | DATE | Y | NULL | 11 > DATA_INIZIO | DATE | N | CURRENT_DATE | 11 > ID | NUMBER | N | NULL | 38 > ID_MACELLAZIONE | NUMBER | N | NULL | 38 > > I tried these queries: > > select count(*) from restrizione where COD_MALATTIA is not null > count(*) > -------- > 0 > > select count(*) from restrizione where COD_MATRICE is not null > count(*) > -------- > 0 > > select count(*) from restrizione where COD_NAZIONE is not null > count(*) > -------- > 0 > > select count(*) from restrizione where DATA_INIZIO is not null > count(*) > -------- > 0 > > select count(*) from restrizione where ID is not null > count(*) > -------- > 0 > > select count(*) from restrizione where ID_MACELLAZIONE is not null > count(*) > -------- > 0 > > select count(*) from restrizione > count(*) > -------- > 0 > > but this one raises the error > > select count(*) from restrizione where DATA_FINE is not null > ORA-03113: end-of-file on communication channel > > Only when I use DATA_FINE column in the WHERE clause it raise the error. > what's wrong with this column? > > Thanks for any help. > > j > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info