functional indexes and database link problems
i am having a problem with a query i have written, a cutdown of the code is shown below. t1.date has a functional index on it "create index idx1 on tab1 (trunc(date))" and t2 is on another database via a db link.
insert into emptytab (id)
select t1.id
from tab1 t1, tab2@dblink t2
where t1.id = t2.id
and trunc(t1.date) = to_date('01/11/2009','dd/mm/yyyy')
when i run this i am receiving the following error message
ORA-03113: end-of-file on communication channel
Process ID: 3466
Session ID: 126 Serial number: 448
if i drop the functional index and rerun the query it works fine, also if i leave the index and create the tab2 table in the same database as tab1 the query works ok as well. So it will work with either the functional index or the db link but not both.