Oracle Database Discussions

Hi,

I would like to create a function based index of my table in Database A with using function from Database B.
How this could be done ?

------------------------------------------------------------------
=====Database A=====
Table MYTABLE (
name varchar2,
value varchar2
)

Public DbLink ABC.WORLD -> DEV.WORLD

=====Database B=====
Function myfunc(oldvalue varchar2)
return newvalue varchar2 Deterministic

------------------------------------------------------------------
the name of db link could not be the same as the host as we use the same db link for different environment
Can this be done ? Thanks in advance.

create index idx_mytable on mytable (name, myfunc@abc.world(value));

SQL Error: ORA-04052: error occurred when looking up remote object USER.myfunc@abc.world
*Cause: An error has occurred when trying to look up a remote object.
*Action: Fix the error. Make sure the remote database system has run
KGLR.SQL to create necessary views used for querying/looking up
objects stored in the database.

Regards,
Raymond