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

Oracle LazyDBA home page