Re: Snapshot !! Desperate!!

You may already realize this, but Oracle7 uses "rowid" snapshots, whereas Oracle8 allows "primary key" snapshots. However, I wonder if this makes any difference when doing a full delete on the master table? I guess if you are saying that it (fast refresh) works sometimes under these circumstances (even in Oracle7), I'll take your word for it. I have a hard time believing it though.

Chuck Wessel

sghariharan_at_inf.com wrote in message <3790a6c5_at_discussions>...
>
>Hi ,
>
> I am facing a bug in Oracle 7.3.2 and I have almost confirmed
>with bug reports that it is a bug, but not fully. Because it
>always doesnt happen.
>
> When I do fast refresh of a snapshot , it fails giving a
>unique constraint violation if,
>
>1. The master table records are fully deleted (ALL Records) and
>reinserted with same key and same values. This , I guess, is
>because Oracle tries to do a insert intoi the snapshot table
>before the delete happens from snapshot table. This happens
>always, even though the unique constraints in master and snapshot
>table are same(It is a product table in my case and both master
>and snapshot have unique index on product_num). I successfully
>deleted and inserted all records(same set of records I re-
>inserted) into master , but FAST refresh!!!Oh!! It fails always,
>if I do this trick. Any comments are welcome.
>
>Thanks very much ,
>Sanjay.
>
>
>--Posted from EarthWeb Discussions. http://discussions.earthweb.com
>
Received on Mon Jul 19 1999 - 14:06:51 CDT