[sebi123]

Create a snapshot or transactional publication from an Oracle Database with the New Publication Wizard. Before creating a publication, you must install Oracle software on the Microsoft SQL Server Distributor, and you must configure the Oracle database. For more information, see Configuring an Oracle Publisher.
The first time you create a publication from an Oracle database, you must identify the Oracle Publisher at the SQL Server Distributor (you do not need to do this for subsequent publications from the same database.). Identifying the Oracle Publisher can be accomplished from the New Publication Wizard or the Distributor Properties - <Distributor> dialog box; this topic shows the Distributor Properties - <Distributor> dialog box.
To identify the Oracle Publisher at the SQL Server Distributor

1. In SQL Server Management Studio, connect to the SQL Server instance that the Oracle Publisher will use as a Distributor, and then expand the server node.
2. Right-click the Replication folder, and then click Distributor Properties.
3. On the Publishers page of the Distributor Properties - <Distributor> dialog box, click Add, and then click Add Oracle Publisher.
4. In the Connect to Server dialog box, click the Options button.
5. On the Login tab:
   
   1. Enter the Oracle database instance name or select Browse for more in the Server instance combo box.
   2. Select Oracle Standard Authentication (recommended) or Windows Authentication.
      If you select Windows Authentication: the Oracle server must be configured to allow connections using Windows credentials (for more information, see the Oracle documentation); and you must be currently logged in with the same Microsoft Windows account you specified for the replication administrative user schema.
   3. If you select Oracle Standard Authentication, enter the login and password of the replication administrative user schema you created on the Oracle Publisher during configuration.
6. On the Connection Properties tab, select a Publisher type of Gateway or Complete.
   The Complete option is designed to provide snapshot and transactional publications with the complete set of supported features for Oracle publishing. The Gateway option provides specific design optimizations to improve performance for cases where replication serves as a gateway between systems. The Gateway option cannot be used if you plan to publish the same table in multiple transactional publications. A table can appear in at most one transactional publication and any number of snapshot publications if you select Gateway.
7. Click Connect, which creates a connection to the Oracle Publisher and configures it for replication. The Connect to Server dialog box closes and you are returned to the Distributor Properties - <Distributor> dialog box.

_________________________
travel insurance for Australians
jamorama review