Hi all   
      
   Probably an easy question for an oracle dba or even power user:   
      
   I would like to copy the data warehouse schema on my laptop for testing and   
   developing our application.   
   - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'.   
   - Fortunately, I don't need the data (ok perhaps a few master data). I need   
   only the schema to avoid 'table not found' errors and so on.   
      
   How can I copy all the tables (mat. views to be correct) without the data   
   from our dwh? But please don't tell me to dump the whole thing and delete   
   the data. DWH and networking team would kill me.   
      
   Good news: no indices, no constraints, just 1 to 1 raw data dumped out of   
   our business solution environment. But I only have access to mat. views and   
   not to the tables directly.   
      
   I tried a create table from select... that did the job more or less but I   
   guess I can't trust it (do mat views identify their underlaying schema   
   correctly?)   
      
   Forgive a spoiled ms developer and thank you in advance   
      
   Raoul   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)