Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help! 10g logical standby not replicating "create table" on standby

706657Jun 12 2009 — edited Jun 12 2009
Hi,
I'm setting up a logical standby environment and everything works, except when I tried to create a simple table on the primary, the table doesn't show up on the standby. I tried creating a new tablespace on the primary and it shows up right away on the standby. I checked the error logs on both primary and standby and no errors.

create table test1 (id number(10) primary key, col1 varchar(20), col2 varchar(20));

The table is created successfully on primary and I also inserted couple of rows and all committed.


I even tried the following query on the standby to check any failed events and the "create table" DDL doesn't show up , even if it failed:

select event_time, status, event from dba_logstdby_events order by event_timestamp, commit_scn

So I'm now confused. The logical standby is active and applying. What would be the issue? How do I find out ?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 12 2009
6 comments
463 views