Re: Materialized view on Solaris remote site returning ORA-02050

"enigma" <mabounajm_at_gmail.com> schreef in bericht news:1163174387.658945.50470_at_e3g2000cwe.googlegroups.com...
> and yes, i did commit.

Grinnnnnnnn ;-)

>
> enigma wrote:
>> 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 Sat Nov 11 2006 - 16:45:29 CST