Re: Can't create simple MV with FAST refresh

2002-09-09 Thread Igor Neyman
Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > > -Original Message- > > From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 09, 2002 1:53 PM > > To: Multiple recipients of list ORACL

RE: Can't create simple MV with FAST refresh

2002-09-09 Thread Jesse, Rich
. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 09, 2002 1:53 PM > To: Multiple recipients of list ORACLE-L > Su

RE: Can't create simple MV with FAST refresh

2002-09-09 Thread Jesse, Rich
Quad/Tech International, Sussex, WI USA > -Original Message- > From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 09, 2002 1:53 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Can't create simple MV with FAST refresh > >

RE: Can't create simple MV with FAST refresh

2002-09-09 Thread Seefelt, Beth
Maybe the IN clause is throwing it? Try it with - where trans_type = 'A' or trans_type = 'B' Just a WAG... Beth -Original Message- Sent: Monday, September 09, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi all, Using 8.1.7.4.0 on HP/UX with COMPATIBILE set to "8.1.7", I'