snapshot / materialized view with column types

From: Geoff Bray <XYZgbhomeboyXYZ-news_at_yahoo.com>
Date: Wed, 02 Jun 2004 20:38:30 GMT
Message-ID: <47c69bb75d6b1bd79e8926cc01612f3e_at_news.teranews.com>

I need to set the column types and lengths in my materialized view that is created with a select as. Anyone able to do this?

Here's one of my gazillion attempts which gave me a syntax error.

Oracle 8.1.7.1 on HP-UX 11.

CREATE SNAPSHOT gb_vw AS
SELECT dummy as test varchar2(2)

   FROM dual

Thanks,
Geoffrey Received on Wed Jun 02 2004 - 22:38:30 CEST