Re: Schema duplication on the same database.
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: drp4kri@xxxxxxxxx
- Date: Thu, 27 May 2010 14:09:54 -0400
You didn't mention your version. Oracle Streams is available in 11g Standard
Edition. ( a fine reason to upgrade ) And though Oracle Replication doesn't
copy packages, procedures, etc is that really a problem? Can you control
schema changes, and just apply them across the "copy" schemas?
Out of curiosity, what are these "copy" schemas going to be used for?
On Thu, May 27, 2010 at 1:09 PM, Dhimant Patel <drp4kri@xxxxxxxxx> wrote:
> 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:
