I am running Oracle 8i
"Dang" <mdang_at_bigpond.com.au> wrote in message
news:c09lc3$7n2$1_at_mws-stat-syd.cdn.telstra.com.au...
>
> I am running a series of Union Queries using a DBLINK.
> My Query ended with
>
> "ORA-01000: maximum open cursor exceeded ORA-02063 preceding line from DB
> LINK"
>
> SELECT A.*
> FROM TABLEA_at_DBLINK A
> UNION ALL
> SELECT B.*
> FROM TABLEB_at_DBLINK B
>
> etc...
>
>
> Would you know how to avoid this error as I cannot cut down my Query in
> size.
>
> Thank You
>
>
Received on Mon Feb 09 2004 - 22:12:33 CST
