Re: Schema duplication on the same database.
- From: Dhimant Patel <drp4kri@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Thu, 27 May 2010 13:09:47 -0400
Yes,
but we need to have it on the same database and not on the standby. In fact
our standby would be our next option if this is not possible on the same
database in almost real time.
-DP
On Thu, May 27, 2010 at 12:17 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
> What oracle version?
>
> IIRC, in 11g you can use standby for read only while the apply is working
> in the background.
> So, you can create a stand by database and let the other 2 users make
> reports from there.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
>
> Dhimant Patel wrote:
>
>> Hi All,
>>
>> I have Oracle Standard Edition installed and have two schema in use (call
>> it prodA, prodB) in this database. I wanted to create two additional
>> schema(s) (copyA and copyB) and want to maintain both in sync with original
>> schema(s). I know streams can not be used since it is only Enterprise
>> version feature. I currently use datapump for schema duplication but this is
>> little bit different - since downtime is not acceptable (hence both should
>> be in sync, almost!).
>>
>> I thought of following:
>>
>> 1> Instead create new users and allow full access to prodA and prodB via
>> synonyms and hope all is ok - since we now have four users and could later
>> on face issues of objects and links all over the place.
>>
>> Didn't like this idea.
>>
>>
>> 2> Use replication for all objects and copy them over to copyA and copyB.
>> It still wont allow copying of stored procedure code, which is large in our
>> case.
>>
>>
>> 3> Could proxy user can help? But I think they are for external users like
>> in the case of application servers etc.
>>
>>
>>
>> Any other ideas?
>> -Thanks,
>> DP.
>>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
