From: nospam@invalid   
      
   "news.magnet.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   
      
   hi raoul   
   sorry for my smal english   
   you can use under linux or unxi  the comandline with EXP   or in oracle   
   10.x. in commandline the expdp   
   in all using help can you see with      exp help=y    oder expdp help=y   
      
   if you ar user with privileg FULL_EXPORT_DATABASE or so ... the tje user   
   can make an export follow   
   exp userid=name/pasword FILE=filname-of-the-exportfile.dmp   
   LOG=name-of-the-logfile.log  USER=name-from-the-user who sould export   
   FULL=n   
      
   please look at teh command detailed. i havent  an manuell in front of   
   me.   
      
   ist used the filedirektory where you actuell are standing.   
   thast all   
   have a good time   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)