ORA-03113: end-of-file on communication channel

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(*)

select count(*) from restrizione where COD_MATRICE is not null count(*)

select count(*) from restrizione where COD_NAZIONE is not null count(*)

select count(*) from restrizione where DATA_INIZIO is not null count(*)

select count(*) from restrizione where ID is not null count(*)

select count(*) from restrizione where ID_MACELLAZIONE is not null count(*)

select count(*) from restrizione
count(*)

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 22 2011 - 06:08:45 CDT