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'm

RE: Can't create simple MV with FAST refresh

2002-09-09 Thread Jesse, Rich
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 Maybe the IN clause is throwing it? Try

RE: Can't create simple MV with FAST refresh

2002-09-09 Thread Jesse, Rich
create simple MV with FAST refresh Maybe the IN clause is throwing it? Try it with - where trans_type = 'A' or trans_type = 'B' Just a WAG... Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services

Re: Can't create simple MV with FAST refresh

2002-09-09 Thread Igor Neyman
-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 Maybe the IN clause is throwing it? Try it with - where trans_type