Re: Wanted: Procedure to clone DB
From: <chadb_at_NeoSoft.com>
Date: 29 Jul 1994 20:48:46 GMT
Message-ID: <31bpve$494_at_uuneo.neosoft.com>
Date: 29 Jul 1994 20:48:46 GMT
Message-ID: <31bpve$494_at_uuneo.neosoft.com>
In <dsfCtJ0C3.21E_at_netcom.com>, dsf_at_netcom.com (Dave Faulkner) writes:
>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?
>
We use Sql*Studio to export all the objects, run the script on the new databse, create database links to copy all the data.
Chad
-- Chad Brockman | VertiComp, Inc | I'm just an OS/2 Junkie!! chadb_at_NeoSoft.com | "Come on kid, it's cheap!!"Received on Fri Jul 29 1994 - 22:48:46 CEST