Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraRepSchemaTable

The oraRepSchema Table contains information about the replicated database schemas at the current site. For each such replicated schema, there exists one instance of this table.

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
Table A - 9. oraRepSchema Table Variables and Corresponding Object ID's

oraRepSchemaIndex

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

oraRepSchemaName

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

oraRepSchemaType

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

oraRepSchemaStatus

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

oraRepSchemaLinks

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

Contents Glossary Index Home Previous Next