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