Re: Migration/Refresh tool

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)