From: XYZgbhomeboyXYZ-news@yahoo.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)