snapshot / materialized view with column types

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 - 15:38:30 CDT