重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 检查逻辑备库是否忽略了某用户 [打印本页]

作者: Inkcup 时间: 3 天前
标题: 检查逻辑备库是否忽略了某用户
-- 检查逻辑备库是否忽略了 zw 用户

-- 在逻辑备库执行：
SELECT * FROM DBA_LOGSTDBY_SKIP;

SQL> r
  1* SELECT * FROM DBA_LOGSTDBY_SKIP

ERROR             STATEMENT_OPT       OWNER             NAME                U E PROC
-------------------- -------------------- -------------------- -------------------- - - --------------------
N                   INTERNAL SCHEMA    ANONYMOUS          %                   N
N                   INTERNAL SCHEMA    APPQOSSYS          %                   N
N                   INTERNAL SCHEMA    AUDSYS             %                   N
N                   INTERNAL SCHEMA    CTXSYS             %                   N
N                   INTERNAL SCHEMA    DBSFWUSER          %                   N
N                   INTERNAL SCHEMA    DBSNMP             %                   N
N                   INTERNAL SCHEMA    DIP                %                   N
N                   INTERNAL SCHEMA    GGSYS             %                   N
N                   INTERNAL SCHEMA    GSMADMIN_INTERNAL %                   N
N                   INTERNAL SCHEMA    GSMCATUSER          %                   N
N                   INTERNAL SCHEMA    GSMUSER             %                   N

ERROR             STATEMENT_OPT       OWNER             NAME                U E PROC
-------------------- -------------------- -------------------- -------------------- - - --------------------
N                   INTERNAL SCHEMA    MDSYS             %                   N
N                   INTERNAL SCHEMA    OJVMSYS             %                   N
N                   INTERNAL SCHEMA    OLAPSYS             %                   N
N                   INTERNAL SCHEMA    ORACLE_OCM          %                   N
N                   INTERNAL SCHEMA    ORDDATA             %                   N
N                   INTERNAL SCHEMA    ORDPLUGINS          %                   N
N                   INTERNAL SCHEMA    ORDSYS             %                   N
N                   INTERNAL SCHEMA    OUTLN             %                   N
N                   INTERNAL SCHEMA    REMOTE_SCHEDULER_AGE %                   N
                                       NT

ERROR             STATEMENT_OPT       OWNER             NAME                U E PROC
-------------------- -------------------- -------------------- -------------------- - - --------------------
N                   INTERNAL SCHEMA    SI_INFORMTN_SCHEMA %                   N
N                   INTERNAL SCHEMA    SYS                %                   N
N                   INTERNAL SCHEMA    SYS$UMF             %                   N
N                   INTERNAL SCHEMA    SYSBACKUP          %                   N
N                   INTERNAL SCHEMA    SYSDG             %                   N
N                   INTERNAL SCHEMA    SYSKM             %                   N
N                   INTERNAL SCHEMA    SYSRAC             %                   N
N                   INTERNAL SCHEMA    SYSTEM             %                   N
N                   INTERNAL SCHEMA    WMSYS             %                   N
N                   INTERNAL SCHEMA    XDB                %                   N
N                   INTERNAL SCHEMA    XS$NULL             %                   N

31 rows selected.

如果 zw 用户被配置为跳过，则该用户下的所有表都不会同步。

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)