Glossary of Terms for Oracle Publishing

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

You should be familiar with the following Oracle terms when configuring and administering Oracle publishing. For a complete list of Oracle terms, see the Oracle online documentation.

Index Organized Tables (IOT)
A table whose data is physically sorted on disk in index order; it is similar to a Microsoft SQL Server table with a clustered index. An IOT is replicated to a Subscriber as a table with a clustered index.

An Oracle database is associated with an instance. The instance comprises the memory and background processes supporting the database. An Oracle instance always maps to a single database, whereas an instance of SQL Server can contain many databases. There are circumstances in which an Oracle database can have multiple instances.

Oracle Listener
Handles incoming network traffic for an Oracle database instance. When you configure network connectivity to an Oracle database, you specify the protocol through which traffic is sent and the port on which the Listener listens for traffic. The Listener is typically configured to run on the same computer as the Oracle database instance and can be configured to serve one or more instances.

A pointer to the location of a specific row in a database. Because retrieving rows using the ROWID is faster than using a table scan or index, replication uses the ROWID temporarily during processing of published table changes.

A database object that is used to generate unique numbers. Replication uses sequences to order changes made to published tables.

An application used to access and query Oracle databases. It is similar to SQL Server sqlcmd.

An alias for an object. The special public synonym MSSQLSERVERDISTRIBUTOR is automatically created when an Oracle Publisher is configured. The synonym references the HREPL_Distributor table and provides a logical pointer to the SQL Server Distributor that services the Publisher.

After an Oracle database has been published, subsequent attempts to configure this Publisher to use a different SQL Server Distributor will fail, because this public synonym identifies the particular Distributor already configured to service the Publisher.

A unit of database storage that is roughly equivalent to a filegroup in SQL Server.

TNS Service Name
TNS (Transparent Network Substrate) is a communication layer used by Oracle databases. The TNS Service Name is the name by which an Oracle database instance is known on a network. You assign a TNS Service Name when you configure connectivity to the Oracle database. Replication uses the TNS Service name to identify the Publisher and to establish connections.

User schema
A user schema can be thought of as a database user who owns a particular set of database objects. The replication administrative user schema owns all objects created by the SQL Server replication process in the Oracle database, with the exception of the MSSQLSERVERDISTRIBUTOR public synonym.

See Also

Configure an Oracle Publisher
Objects Created on the Oracle Publisher
Non-SQL Server Publishers
Oracle Publishing Overview