From: raoul@nospam.minder.name   
      
   Sorry for the sender name, just set up my news account...   
      
      
   "news.magnet.ch >"  schrieb im   
   Newsbeitrag news:53b41$48b47eaf$d5bd8e11$20531@news.cyberlink.ch...   
   > 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)