Hi Kirti,

Getting following error message, when refresh takes place on replication
site
BEGIN DBMS_REFRESH.REFRESH ('PIRSREP_REFRESH'); END;

*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 125012 bytes
(callheap,KQL tmpbuf)
ORA-00600: internal error code, arguments: [18090], [16737], [], [], [], [],
[], []
ORA-12008: error in snapshot refresh path
ORA-04030: out of process memory when trying to allocate 65056 bytes (RPC
Heap,RPC Heap)
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_IREFRESH", line 577
ORA-06512: at "SYS.DBMS_REFRESH", line 211
ORA-06512: at line 1

Oracle Database : 8.1.7.1.3
Operation System : Windows NT 4
The table getting replicated has about 500 thousands records containnig CLOB
data.
It works fine with 10,000 records.


Ajaz
Oracle LazyDBA home page