On the Articles page, you specify which database objects to include as articles in the publication. If you are publishing a database object that depends on one or more other database objects, you must publish all referenced objects. For example, if you publish a view that depends on a table, you must publish the table also.
Objects that cannot be published have a red icon next to them, with an explanation in the information panel at the bottom of the wizard page. The following objects cannot be published:
Indexed views containing columns that allow NULL.
Tables without primary keys cannot be published in transactional publications.
Tables cannot be published in both a merge publication and a transactional publication enabled for queued updating subscriptions. For more information about publishing an article in more than one publication, see the "Publishing Tables in More Than One Publication" section in Publishing Data and Database Objects.
There are additional considerations for Oracle Publishers:
For a list of objects that can be published from Oracle, see Design Considerations and Limitations for Oracle Publishers. Objects that cannot be published are not displayed.
For a list of data types that can be published, see Data Type Mapping for Oracle Publishers. Columns with data types that cannot be published are not displayed.
Filter columns on this page by expanding a table in the Objects to publish pane and then selecting only the columns required (rows can be filtered in the Filter Table Rows page of this wizard). Filtering columns is useful for a number of reasons, including security (preventing sensitive data from being replicated) and performance (avoiding replication of large binary large object (BLOB) columns, for example). For more information about column filtering, including a list of column types that cannot be filtered, see Filtering Published Data.
The Objects to publish pane allows you to:
View all objects available for replication.
Include an object in a publication by selecting the check box next to that object.
Include all objects of a particular type (such as a table) in the publication by selecting the check box next to that object type (such as Tables).
Expand table nodes to see the columns in the table.
Filter table columns out of a publication by clearing the check box next to the column.
Right-click an object in the pane to see a menu of commands for that object.