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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Migration/Refresh tool

Re: Migration/Refresh tool

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 10 Jan 2006 08:44:35 -0800
Message-ID: <1136911467.617831@jetspin.drizzle.com>


Magnus Andersen wrote:
> That is what I thought and stated previously in this thread. It has
> been suggested that I merged my 4 instances/dbs that I have running on
> the same server to 1 instance/db. I still really like the idea since
> it would allow me to share resources, i.e. SGA, between the different
> schemas that I am now unable to do since they are all separate.
>
> The only issue I saw was regarding the tables in the schemas being the
> same and that I didn't have to change the schema owner in all my
> applications when I migrate an application from DEV to TST. That would
> be a lot of overhead to have to deal with everytime a migration would
> need to happen. I still don't know of a way to get around that issue.
>
> Any ideas out there since it seams to me that synonyms will not work in
> this case.
>
> Thanks,
> Magnus Andersen

Still unclear why private synonyms won't work. Can you explain the reason.

BTW: You could connect from PROD to the four schemas using four different database links and maintain the logical appearance of four separate databases.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jan 10 2006 - 10:44:35 CST

Original text of this message

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