Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: struggeling with replication
EdStevens wrote:
> OK, this is TOO bizarre! There would appear to be some sort of timing
> issue. If I run my build_mv.sql script (which contains a series of
> '@create_<mv_name>.sql' type statements, immediately after running it
> once, I get the ora-00904 failures as described earlier. If I go get
> coffee, then come back and run it, all ten MV's create just fine. And
> when there are failures, it is not consistent on which ones fail. All
> this without touching any of the code in any of the scripts. Ever
> heard of any thing like this, or have any theories?
>
> And remember, the MV site is 10.2 and the master site is 8.1.7.4.
>
I pass. Maybe I'll resurrect my 8i one day, and I'll try some test setup - but I wouldn't hold my breath until then. (had some airfield weather statistics gathering app built in 8i)
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Wed Apr 26 2006 - 12:57:00 CDT