Share via


Objects Created on the Oracle Publisher

Microsoft SQL Server replication installs database objects on the Oracle Publisher to enable change tracking and forwarding (SQL Server does not install any binary files on the Oracle Publisher). The following table lists the objects that are created at the Oracle Publisher when it is identified as a Publisher at the SQL Server Distributor. The object descriptions are provided for informational purposes only. These objects should not be modified.

Object Name

Object Type

Description

HREPL_ArticleNlog_V

Table

Change tracking table used to store information as changes are made to the published table. A change tracking table is created for each published table.

HREPL_Changes

Table

Table used internally by the Xactset Job to determine the number of changes waiting to be assigned to a transaction set. For more information about this job, see Performance Tuning for Oracle Publishers.

HREPL_Distributor

Table

Distributor status table used to maintain information about the SQL Server Distributor associated with the Oracle Publisher.

HREPL_Event

Table

Event table used for synchronizing snapshots and row count requests.

HREPL_Mutex

Table

Table used to ensure that the Oracle package procedure PopulatePollTable is not executed concurrently by both the Log Reader Agent and the database job.

HREPL_Poll

Table

Table used to identify log table entries associated with sets of changes to published tables.

HREPL_PublishedTables

Table

Table containing an entry for each article in a transactional publication.

HREPL_Publisher

Table

Publisher status table used for maintaining Publisher specific information.

HREPL_SchemaFilter

Table

Table containing schemas that are not displayed when publishing through the New Publication Wizard.

HREPL_XactsetCreateTimes

Table

Table identifying the create time associated with each transaction set.

HREPL_XactsetJob

Table

Table with current parameter settings for the Xactset Job.

HREPL_Pollid

Sequence

Sequence used to generate poll IDs.

HREPL_Seq

Sequence

Sequence used to order change commands.

HREPL_Stmt

Sequence

Sequence used to generate statement IDs.

HREPL

Package and Package Body

Package of Publisher support code that is created at the Publisher.

MSSQLSERVERDISTRIBUTOR

Public Synonym

Public synonym for the HREPL_Distributor table. If you configure a Distributor to use with an Oracle Publisher, and this synonym already exists in the database, it is dropped and recreated.

Dropping the public synonym and the configured Oracle replication user with the CASCADE option removes all replication objects from the Oracle Publisher.

HREPL_Len_I_J_K

Function

Function defined outside the Oracle publishing package code, used to query for the length of a LONG column (used when generating parameterized commands for tables with published LONG columns). A function is created for each published table with a LONG column.

HREPL_DropPublisher

Procedure

Procedure defined outside the Oracle publishing package code, used to drop the Oracle Publisher.

HREPL_ExecuteCommand

Procedure

Procedure defined outside the Oracle publishing package code, used to execute a command at the Publisher.

HREPL_ArticleN_Trigger_Row

Trigger

Trigger generated for each published table, used to track row changes.

HREPL_ArticleN_Trigger_Stmt

Trigger

Trigger generated for each published table, used to track statement level changes.

HREPL_Article_I_J

View

View created for each published table, used to query the published table.

HREPL_Log_I_J_K

View

View created for each published table, used to query the change tracking table.

See Also

Concepts

Configure an Oracle Publisher

Glossary of Terms for Oracle Publishing

Oracle Publishing Overview