In this post, you’ll learn more about the Oracle ErrorORA-31466: no publications found with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-31466: no publications found
Reason for the Error ORA-31466: no publications found
Did not find any publications that matched the input parameters or the user does not have the privileges to access the specified publication.
How to fix the Error ORA-31466: no publications found ?
You can fix this error in Oracle by following the below steps
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.