Re: truncating snapshots

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Fri, 14 Sep 2001 14:28:41 -0700
Message-ID: <F001.0038F77B.20010914144136@fatcity.com>

!! Please do not post Off Topic to this List !!

I don't quite understand. You mention "fast snapshots". There's no such thing as a "fast snapshot", only fast refresh, which applies changes from the snapshot log on the master table. If you were to truncate the underlying snapshot table and then attempt a fast refresh, the refresh would fail.

I think you want to do complete refreshes of your snapshots. They start out by truncating the snapshot table.

• Henry Poras <Henry.Poras_at_ctp.com> wrote:
  >
  > I need to move the changes in a table from one database to another.
  > It
  > seemed that fast snapshots would be a good way to do this as the
  > database
  > will automatically keep track of the changes for me. The question is
  > that
  > once I move the data to the snapshot side, I need to manipulate it,
  > move it
  > into another table, and start the cycle again. This means truncating
  > the
  > snapshot between refreshes. I tried this on a test system and it
  > seesm to
  > work, but I don't think Oracle supports it. I don't want updatable
  > snapshots
  > as this is strictly one way movement of data. Has anyone else tried
  > this?
  > Are there any potential problems? I think I am just truncating a
  > table
  > underlying the snapshot view so I don't see what could go wrong.
  >
  

  ---

Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: treegarden_at_yahoo.com

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 Fri Sep 14 2001 - 16:28:41 CDT