Category Archives: ORA Database Error Messages

ORA-31428: no publication contains all the specified columns

oracle

ORA-31428: no publication contains all the specified columns
Cause: One or more of the specifed columns cannot be found in a single publication
Action: Change the subscription request to select only columns that are in the same publication. Consult the USER_PUBLISHED_COLUMNS view to see current publications

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31427: publication string already subscribed

oracle

ORA-31427: publication string already subscribed
Cause: The subscription already contained this publication
Action: Check the values of subscription_name and publication_id. Check any other subscribe calls to see if they subscribe to columns that are shared among more than one publication on the same source table. Do not attempt to subscribe to the same publication more than once in the same subscription. Use the publication_id variant of the SUBSCRIBE call if needed to specify precise publications

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31426: cannot modify active subscriptions

oracle

ORA-31426: cannot modify active subscriptions
Cause: The subscription was already activated so that additional calls to SUBSCRIBE were prohibited
Action: Subscribe to all the desired tables and columns before activating the subscription. Ensure that the correct subscription name is specifed

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31425: subscription does not exist

oracle

ORA-31425: subscription does not exist
Cause: The subscription either did not exist or did not belong to this user
Action: Call the function again with a valid subscription name

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31424: change table has active subscriptions

oracle

ORA-31424: change table has active subscriptions
Cause: The change table is subscribed to, so it cannot be dropped
Action: Do not drop a change table while there are active subscribers. If this is an emergency, use the FORCE parameter. This will forcibly drop the change table out from under all subscribers

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31423: change table string does not contain column string

oracle

ORA-31423: change table string does not contain column string
Cause: Issued ALTER_CHANGE_TABLE with a drop operation and the specified column does not exist in the change table
Action: Recheck the names, and call the procedure again

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31422: owner schema string does not exist

oracle

ORA-31422: owner schema string does not exist
Cause: Value specifed for the owner parameter does not contain the name of an existing schema in the database
Action: Recheck the name, and call the procedure again using an existing schema name

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31421: change table does not exist

oracle

ORA-31421: change table does not exist
Cause: Specified change table does not exist
Action: Recheck the name, and call the procedure again using an existing change table

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31420: unable to submit the purge job

oracle

ORA-31420: unable to submit the purge job
Cause: When creating the first change table, a purge job is submitted to the job queue. Submission of this purge job failed
Action: Make sure that job queue processes are enabled and are currently running. If this does not solve the problem, contact Oracle

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31419: source table string does not exist

oracle

ORA-31419: source table string does not exist
Cause: When creating a synchronous change table, the underlying source table must exist when the procedure is called. In this case, the source table did not exist
Action: Specify the name of an existing table

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/