Re: Wanted: Procedure to clone DB

Dave Faulkner (dsf_at_netcom.com) wrote:
: I am running two Oracle 7 database servers - a production & a development
: each with it's own Oracle license. What is the smoothest method of
: "cloning" my development db to the production machine now that I'm
: ready to deploy a new application. I imagine that export/import is
: the way to go, but how much do I export and how would I work around
: integrity contraints during the import?
 

: Thanks much in advance.
 

: Dave

I have a very similar problem.

 I have tried using export / import but I have PL/SQL procedures that have dependancies on each other and they are imported in alphabetic order so they just dont compile and are left in the INVALID state.

 needless to say I would be very interested in any replies you recieve

  regards

   Pavel Received on Fri Jul 29 1994 - 18:00:47 CEST