in primary database
SQL> show user
USER is "SYS
SQL> create table t1 (id int primary key);
Table created.
SQL> insert into t1 values(1);
1 row created.
SQL> commit;
Commit complete.
in logical standby database
SQL> show user
USER is "SYS"
SQL> desc t1;
ERROR:
ORA-04043: object t1 does not exist
======================================================
in primary database
SQL> show user;
USER is "SCOTT"
SQL> create table tt (id int primary key);
Table created.
SQL> insert into tt values(1);
c
1 row created.
SQL> ommit;
Commit complete.
SQL> insert into tt values(2);
1 row created.
SQL> commit
2;
Commit complete.
SQL> select * from tt;
ID
----------
1
2
in logical standby database
SQL> show user
USER is "SCOTT"
SQL> select * from tt;
ID
----------
1
2
