Oracle Error ORA-31466: no publications found

Oracle Error Message

ORA-31466: no publications found

Reason for the Error

Did not find any publications that matched the input parameters or the user does not have the privileges to access the specified publication.

Solution

Check the input parameters on the call to SUBSCRIBE. Validate that the proposed source table has been published by checking the USER_PUBLICATIONS view for that source table. Contact the publisher if user privileges are required to access the publication. Retry the command with correct security or publication information.