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