Re: meld 5 instances into 1?

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Thu, 12 Aug 1999 10:47:42 -0400
Message-ID: <7oumrg$j5s$1@msunews.cl.msu.edu>

You should decide which instant will be the master. Create links from the master to each of the sub instances. Using the links, pull the data and objects over with the appropriate DML/DDL.

You will have to watch your resources to insure you have space in your master instance to support the new/imported data. You might also need to put the data into staging tables and clean it of duplicates, foreign key issues, and other constraint violations.

Christopher Weiss
Professional Services Division
Compuware Corporation

James Thomson <itabl7up_at_yahoo.com> wrote in message news:7ouk1a$4mb$1_at_nnrp1.deja.com...
> Has anyone had any experience melding 5 instances into 1? Is it
> possible?
>
> --
> ---------------------------
> James Thomson
> itabl7up_at_yahoo.com
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 12 1999 - 09:47:42 CDT