Materialized view on Solaris remote site returning ORA-02050

Hello,

I have a database MAZEN on my local WinXP machine. on my LAN i have another SOLARIS machine that has another database ADM

on my local machine, i create a database link using:

create public database link SOLARIS2 connect to ADM identified by ****** using 'SOLARIS2';

to check if it works, I
select * from RT_MANUFACTURER_at_SOLARIS2;
returns correct result.

on the SOLARIS machine, I
CREATE MATERIALIZED VIEW LOG ON RT_MANUFACTURER; and then on the local machine I try to,
create materialized view snpp refresh fast start with sysdate next sysdate + 1/14400 as select * from RT_MANUFACTURER_at_SOLARIS2;

This returns the following errors:

ORA-04052: error occurred when looking up remote object ADM.RT_MANUFACTURER_at_SOLARIS2
ORA-00600: internal error code, arguments: [kglsprr], [0x69FF573C], [], [], [], [], [], []

although this might seem weird...but when i redo the create materialized view again, a different set of errors pop up: ORA-02050: transaction 3.4.2308 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from SOLARIS2 ORA-03120: two-task conversion routine: integer overflow

The two set of errors happen in alternating fashion...

Alot of users have the same problem (in other forums) but couldn't find a useful answer

Any help is greatly appreciated..

Thankyou.

Mazen Received on Fri Nov 10 2006 - 09:54:05 CST