and yes, i did commit.
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 Fri Nov 10 2006 - 09:59:47 CST
