Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copy Prdoduction database to Test database on different machine

Re: Copy Prdoduction database to Test database on different machine

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Thu, 5 Feb 2004 15:42:07 -0000
Message-ID: <1075995608.32003.0@nnrp-t71-01.news.uk.clara.net> 





> Which steps do I have to take or which scripts do I have to run?




imp/exp with FULL=Y option or if your tablespaces already exist



exp each of your users and import them from system with fromuser and touser



these are easily scripted



thanks
Received on Thu Feb 05 2004 - 09:42:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US