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: purge

Re: purge

From: Anurag Varma <avoracle_at_gmail.com>
Date: 18 Aug 2006 07:17:32 -0700
Message-ID: <1155910652.123554.86920@h48g2000cwc.googlegroups.com>

mike7411_at_gmail.com wrote:
> Does the PURGE function in DBMS_DEFER_SYS just delete the transaction
> data? Or does it apply the transactions before deleting?
>
> Thanks.

Do us and yourself a favor. Read a manual or something!

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96568/rardefsy.htm#94375

PURGE Function

This function purges pushed transactions from the deferred transaction queue at your current master site or materialized view site.

.... Need I say more?

Anurag Received on Fri Aug 18 2006 - 09:17:32 CDT

Original text of this message

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