From: anacedent@hotmail.com   
      
   "Raoul Minder"  wrote in   
   news:5a345$48b4822c$d5bd8e11$22278@news.cyberlink.ch:   
      
   > Sorry for the sender name, just set up my news account...   
   >   
   >   
   > 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   
   >   
   >   
   >   
   >   
      
   use export/import [exp/imp]   
   You can use ROWS=NO on either utility   
   Therefore you can get all the objects without any data;   
   very small footprint.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)