ORA-14074 - partition bound must collate higher than that of the last partition (4298224)

Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

ORA-14074 - partition bound must collate higher than that of the last partition
Description

When new partitions are added on the source database, Post stops as follows:

Notice 2013-10-03 12:36:36.691414 28240 3188107584 s:7 Poster: ORA-14074: partition bound must collate higher than that of the last partition. (posting from SID1, queue queue_name, to SID2) [module osp]
Error 2013-10-03 12:36:36.691925 28240 3188107584 s:7 Poster: Poster exit on ddl error due to ORA-14074: partition bound must collate higher than that of the last partition. on ALTER TABLE "OWNER"."TABLE_NAME" ADD PARTITION P_201401 ... (posting from SID1, queue queue_name, to SID2) [module opo]
Info 2013-10-03 12:36:36.805878 30307 2146536528 Poster exited with code=1, pid = 28240 (posting from SID1, queue queue_name, to SID2).
Cause

Partition bound specified in ALTER TABLE ADD PARTITION statement did not collate higher than that of the table's last partition.
Résolution

Ignore the DDL error by setting the following parameter on target sp_ctrl:

sp_ctrl>set param SP_OPO_STOP_ON_DDL_ERR 0
sp_ctrl>start post
Once the error has been bypassed, then unset the parameter by:
sp_ctrl>reset param SP_OPO_STOP_ON_DDL_ERR
sp_ctrl>stop post
sp_ctrl>start post

For future changes to partition, ensure that the partition bound of the partition to be added collates higher than that of the table's last partition.
For now, one can manually add the partition on the target table during a quiet time and resync that partition as appropriate.
Informations supplémentaires

Here is the description of the ORA-14074: ORA-14074 - partition bound must collate higher than that of the last partition Cause - Partition bound specified in ALTER TABLE ADD PARTITION statement did not collate higher than that of the table's last partition, which is illegal. Action - Ensure that the partition bound of the partition to be added collates higher than that of the table's last partition.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Demander un article de la base de connaissances

Contenu recommandé

Produit(s) :: SharePlex
9.2.8, 9.2.7, 9.2.6, 9.2.5, 9.2.4, 9.2.3, 9.2.1, 9.2, Future

Sujet(s) :: Troubleshooting

Historique de l’article :: Créé le : 10/24/2013
Dernière mise à jour le : 5/7/2023

Rechercher tous les articles

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

ORA-14074 - partition bound must collate higher than that of the last partition (4298224)

Titre

Description

Cause

Résolution

Informations supplémentaires

Leave a Comment