The values of these variables are retrieved directly from the replication catalog. The current replication environment's status (normal, quiescing, quiesced) and configuration (type of replication site and database link to remote replication sites) are useful for displaying a visual representation of the replication environment.
Variable Name | Object ID |
oraRepSchemaIndex | 1.3.6.1.4.1.111.4.3.2.1.1 |
oraRepSchemaName | 1.3.6.1.4.1.111.4.3.2.1.2 |
oraRepSchemaType | 1.3.6.1.4.1.111.4.3.2.1.3 |
oraRepSchemaStatus | 1.3.6.1.4.1.111.4.3.2.1.4 |
oraRepSchemaLinks | 1.3.6.1.4.1.111.4.3.2.1.5 |
Syntax | INTEGER32 |
Max-Access | read-only |
Explanation | This is a numeric index unique among replication schemas contained in this database. |
Typical Range | not applicable |
Significance | Provides a unique identifier for the schema. |
Related Variables | none |
Suggested Presentation | simple string |
Syntax | DisplayString |
Max-Access | read-only |
Explanation | This is the name of the replicated schema. This name must be the same at all sites involved in the replication of the schema. |
Typical Range | valid Oracle identifier |
Significance | Identifies replicated schemas. Useful in displaying a visual representation of the replication environment. |
Related Variables | oraRepSchemaType |
Suggested Presentation | simple string |
Syntax | INTEGER{masterdef(1), master(2), snapshot(3)} |
Max-Access | read-only |
Explanation | This indicates whether the replicated schema is a master definition schema, a master schema, or a snapshot schema. |
Typical Range | not applicable |
Significance | Most replication administration tasks can be performed only at the master definition sites. |
Related Variables | oraRepSchemaName |
Suggested Presentation | color indicator or simple string |
Syntax | INTEGER{normal(1), quiescing(2), quiesced(3)} |
Max-Access | read-only |
Explanation | This indicates the state of the replicated schema. Replication activity is suspended in the quiesced state and the schema can then be altered. |
Typical Range | 1 - 3 |
Significance | The meanings of the values are as follows: |
1 - Normal operational state of a replication environment. | |
2 - Replication activity is in the process of being suspended | |
3 - Repliction activity has been disabled. This is usually done to perform administrative actions. | |
Snapshot sites are always in state 1 (normal). | |
Related Variables | oraRepSchemaType |
Suggested Presentation | color indicator or simple string |
Syntax | INTEGER32 |
Max-Access | read-only |
Explanation | This indicates the number of database links used in the schema for replication. |
Typical Range | configuration dependent |
Significance | For masters there must be at least one database link from the local site to each remote master. |
For snapshots there must be at least one database link from the snapshot site to its master. | |
Related Variables | oraRepLinkName |
Suggested Presentation | simple string |