Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Materialized view on Solaris remote site returning ORA-02050

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

From: enigma <mabounajm_at_gmail.com>
Date: 12 Nov 2006 11:27:50 -0800
Message-ID: <1163359670.737578.246810@e3g2000cwe.googlegroups.com>


Hi,

Couldn't log on to that site...
Sorry but i don't know what na SR is..
Any other ideas? Anyone?

Thankyou

On Nov 12, 12:45 am, "What's in a namespace" <x..._at_ns.com> wrote:
> "enigma" <maboun..._at_gmail.com> schreef in berichtnews: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- Hide quoted text -- Show quoted text -
Received on Sun Nov 12 2006 - 13:27:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US