High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

11.2.0.4 logical DG - Skip GRANT on table

edited Jun 17, 2014 5:02AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered ✓

Hi there

Any comments most welcome ...

On the primary, if I have 2 schemas:

STORM

DISCOV_USER

I grant number of tables in STORM schema SELECT to DISCOV_USER.

This his replicated down to standby.

It trips and generates error message

Status - ORA-12705 Cannot access NLS data file..

Event - Grant Select on STORM.Table1 to DISCOV_USER

I should mention, Logical standby, will have schema DISCOV_USER, as stand-a-lone for reporting purposes.  No changes enforced from Primary.

Tried

exec dbms_logstdby.skip &  dbms_logstdby.skip_error - combination of rules without success.

Result, the logs are being copied over but not applied.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center