RE: Are snapshot logs purged?

From: <Scott.Shafer_at_dcpds.cpms.osd.mil>
Date: Wed, 14 Feb 2001 11:52:44 -0800
Message-ID: <F001.002B46AC.20010214113059@fatcity.com>

See dbms_snapshot.purge_log() in the PL/SQL Supplied Packages Reference.

---

---

PURGE_LOG procedure

This procedure purges rows from the snapshot log.

Syntax

DBMS_SNAPSHOT.PURGE_LOG (

   master        IN   VARCHAR2,
   num           IN   BINARY_INTEGER := 1,
   flag          IN   VARCHAR2       := 'NOP');
----------------------------------------------------------------------------

---

--Scott Shafer
  San Antonio, TX

> -----Original Message-----
> From: Bala Muru [SMTP:muru_oracle_at_yahoo.com]
> Sent: Wednesday, February 14, 2001 11:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Are snapshot logs purged?
>
> Hello Lists,
>
> I have a set of snapshots refreshing in FAST mode
> using snapshot logs. The snapshot log is keep-on
> growing as it should and after certain amount of time,
> I had to expand the tablespace space under which the
> snapshot log is located.
>
> My question is, Is there a way to periodically
> truncate or remove records from snapshot logs? Of
> course we can make something on our own by scheduling
> some delete jobs, but, Is there any default method
> available in Oracle?
>
> Any input would be highly appreciated.
>
> Thanks in advance,
> Muru
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 14 2001 - 13:52:44 CST