Yes, I learned there were some hoops in logical standby. However, can a
package be executed in a physical standby database?

Thanks

Titus

----- Original Message -----
From: " (Frank Dodgers)"
<oracledba-ezmlmshield-x29378068.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 31, 2004 3:42 PM
Subject: Re: Execute privilege on Standby Databases?


>I don't want to sound like DG (Data Guard) is a bad idea, but I do want to
>caution you that it requires significant baby-sitting. Both DG Physical
>and DG Logical should only be queried. There are ways around this as
>documented, but be very careful. We run both DG Physical and Logical for
>various valid reasons. One example of an issue is in one of our DG Logical
>databases we allow rows to change in the standby. Every now and then a
>change is made in the primary and DG tries to apply the same change to the
>standby and the row does not exist or the key is different, etc. At that
>point we have to stop apply, and resync, yatta, yatta, yatta...........get
>a lot of ORA-00600's too.
>
> My suggestion is to look before you leap.
>
>
> --
> Thank You,
> Frank Dodgers
> Oracle & DB2 Certified
> Evergreen Information Systems
> -303-784-2322 Office
> -303-674-0433 Home
> -303-810-6625 Cell
> frank.[Email address protected]
>
>
> -------------- Original message from "Titus Olowok " : --------------
>
>> Hello Folks,
>>
>> We are suggesting using Oracle 9i Data Guard for reporting purposes for a
>> project. The operations in the reporting Standby database (Physical
>> Standby)
>> will be mainly read only, executing custom packages to generate reports
>> and
>> querying temporary tables.
>>
>> A colleage had mentioned that you can NOT execute a package in a physical
>> standby database in 'read only' mode, only 'SELECT' privilege is allowed.
>> Before
>> I create a standby configuration on my local machine and test, I want to
>> run
>> this by the group first.
>>
>> Does physical Standby configuration in 'read only' mode support only
>> 'SELECT'
>> statements? Can packages or other stored procedures be executed as well?
>>
>> Thanks for sharing your thoughts
>>
>> Titus
>>
>>
>> --------
>> website: http://www.LazyDBA.com
>> Please don't reply to RTFM questions
>> Oracle documentation is here: http://tahiti.oracle.com
>> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>> To subscribe: see http://www.lazydba.com
>> By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page