Name

REPL_STAT — retrieve status of all subscriptions and publications

Synopsis

REPL_STAT ( );
 

Description

Retrieves status of all subscriptions and publications. This function is for interactive use (via ISQL tool).

Example

Example 24.331. Retrieving of the replication status

This is to show status of the subscriptions. The server shows the name of publisher, account is a name of the publication account, level is a current level of the publication and stat is a current status of the publication/subscription. Note that status for local publications are shown always as OFF, it is to show only subscription status.

SQL> DB.DBA.REPL_STAT ();
server                    account                   level       stat
VARCHAR                   VARCHAR                   INTEGER     INTEGER
_______________________________________________________________________________

my-rep                    my-rep                    0           OFF
demo-rep1                 demo_tb                   3           IN SYNC