!! 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).