Re: DB Merge Ideas?
- From: amihay gonen <agonenil@xxxxxxxxx>
- To: napacunningham@xxxxxxxxx
- Date: Thu, 18 Dec 2014 08:46:36 +0200
Use pdb
On 18 Dec 2014 01:51, "Michael Cunningham" <napacunningham@xxxxxxxxx> wrote:
> Hello list,
>
> We have 16 similar instances that we want to merge into a single
> instance. I'm looking for input on the best method. Below is all I could
> think of to help.
>
> Oracle 12.1.0.1 on Linux
> All instances exist on the same server.
> ASM is being used. Currently one diskgroup for all instances.
> No tables have the same name.
> The tablespaces that matter do not have the same name between databases
> (one db is TBS0, another is TBS1, and so on).
> Each is around 500GB (5.5TB total).
> We do not have golden gate license.
>
> Any thoughts?
>
> I'm thinking of transportable tablespaces, but I'm looking for other
> input. I need to minimize downtime.
>
>
> --
> Michael Cunningham
>
Other related posts:
