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

MOSC Banner

DBMS_LOGSTDBY.INSTANTIATE_TABLE returns "ORA-20001 fixing up the name in the impdp stat table"

One of our clients had the above problem, just after applying a patch to our product's schema, and now I've been able to reproduce it on a local database. In my test I have a Primary and Logical Standby both running on my Windows desktop on EE 12.1.0.2.0. I've recently recreated the Standby and it has been working correctly after making changes to the Primary, I've switched log files and seen V$LOGSTDBY_PROGRESS is up to date as it should be.

As SYS on the Standby with logical apply not running...

CREATE PUBLIC DATABASE LINK PRIM CONNECT TO SYSTEM IDENTIFIED BY <pass> USING 'PRIM';

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center