[sebi123]

1. Connect to the SQL Server instance that the Oracle Publisher will use as a Distributor, and then expand the server node.
2. Expand the Replication folder.
3. Right-click the Local Publications folder, and then click New Oracle Publication.
4. On the Oracle Publisher page of the New Publication Wizard, select the Oracle Publisher. If the Oracle Publisher is not displayed, click Add Oracle Publisher, which takes you through the steps from the previous procedure.
5. On the Publication Type page, select Snapshot publication or Transactional publication.
6. On the Articles page, select the database objects you want to publish.
   Optionally, filter out table columns by expanding a table and then clearing the checkbox for one or more columns. Click Article Properties to view and modify article properties and to specify alternative data type mappings if necessary. For more information about data type mappings, see How to: Specify Data Type Mappings for an Oracle Publisher (SQL Server Management Studio).
7. On the Filter Table Rows page, optionally apply filters to publish a subset of data from one or more tables.
8. On the Snapshot Agent page, clear Create a snapshot immediately only if you have created all objects and added all required data in the subscription database.
9. On the Agent Security page, specify credentials for the Snapshot Agent (for all publications) and the Log Reader Agent (for transactional publications). The agents run and make connections to the SQL Server Distributor using the context of the Microsoft Windows account you specify. The agents make connections to the Oracle database using the context of the account you specified as the replication administrative user schema. For more information, see Configuring an Oracle Publisher.
   For more information about the permissions required by each agent, see Replication Agent Security Model and Replication Security Best Practices.
10. On the Wizard Actions page, optionally script the publication. For more information, see Scripting Replication.
11. On the Complete the Wizard page, specify a name for the publication.

______________________________
travel insurance for Australians
jamorama review

[johnpitter]

Nice Information shared by you. I am a newbie in the world of Oracle. There are so many good features in oracle.