Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Cannot add a partition to my table

Dennis RussellJan 9 2024 — edited Jan 9 2024

I have a partition that I am adding after another partion

Here is my select statement to list the partition

SELECT table_name, partition_name, num_rows, p.high_value
FROM dba_tab_partitions p
WHERE table_name= 'MINVENTORY'
and partition_name like 'MINVENTORY_51_2023%'
ORDER BY 1,2;

<table><tbody><tr><td style="height:12.75pt;width:101pt;">TABLE_NAME</td><td style="width:134pt;">PARTITION_NAME</td><td style="width:112pt;">NUM_ROWS</td><td style="width:180pt;">HIGH_VALUE</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202301</td><td style="text-align:right;">283,061</td><td>51, 202302</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202302</td><td style="text-align:right;">282,273</td><td>51, 202303</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202303</td><td style="text-align:right;">281,985</td><td>51, 202304</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202304</td><td style="text-align:right;">286,719</td><td>51, 202305</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202305</td><td style="text-align:right;">282,937</td><td>51, 202306</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202306</td><td style="text-align:right;">282,470</td><td>51, 202307</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202307</td><td style="text-align:right;">284,183</td><td>51, 202308</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202308</td><td style="text-align:right;">284,422</td><td>51, 202309</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202309</td><td style="text-align:right;">284,389</td><td>51, 202310</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202310</td><td style="text-align:right;">284,306</td><td>51, 202311</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202311</td><td style="text-align:right;">285,418</td><td>51, 202312</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202312</td><td style="text-align:right;">285,110</td><td>51, 202313</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202313</td><td style="text-align:right;">285,397</td><td>51, 202314</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202314</td><td style="text-align:right;">285,403</td><td>51, 202315</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202315</td><td style="text-align:right;">287,514</td><td>51, 202316</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202316</td><td style="text-align:right;">286,070</td><td>51, 202317</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202317</td><td style="text-align:right;">285,490</td><td>51, 202318</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202318</td><td style="text-align:right;">285,450</td><td>51, 202319</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202319</td><td style="text-align:right;">286,736</td><td>51, 202320</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202320</td><td style="text-align:right;">287,590</td><td>51, 202321</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202321</td><td style="text-align:right;">288,702</td><td>51, 202322</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202322</td><td style="text-align:right;">288,712</td><td>51, 202323</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202323</td><td style="text-align:right;">288,557</td><td>51, 202324</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202324</td><td style="text-align:right;">291,495</td><td>51, 202325</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202325</td><td style="text-align:right;">295,325</td><td>51, 202326</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202326</td><td style="text-align:right;">297,490</td><td>51, 202327</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202327</td><td style="text-align:right;">294,487</td><td>51, 202328</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202328</td><td style="text-align:right;">296,452</td><td>51, 202329</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202329</td><td style="text-align:right;">297,993</td><td>51, 202330</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202330</td><td style="text-align:right;">296,061</td><td>51, 202331</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202331</td><td style="text-align:right;">294,436</td><td>51, 202332</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202332</td><td style="text-align:right;">292,570</td><td>51, 202333</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202333</td><td style="text-align:right;">295,456</td><td>51, 202334</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202334</td><td style="text-align:right;">293,288</td><td>51, 202335</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202335</td><td style="text-align:right;">292,727</td><td>51, 202336</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202336</td><td style="text-align:right;">278,016</td><td>51, 202337</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202337</td><td style="text-align:right;">278,563</td><td>51, 202338</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202338</td><td style="text-align:right;">278,924</td><td>51, 202339</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202339</td><td style="text-align:right;">278,817</td><td>51, 202340</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202340</td><td style="text-align:right;">278,011</td><td>51, 202341</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202341</td><td style="text-align:right;">277,809</td><td>51, 202342</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202342</td><td style="text-align:right;">277,424</td><td>51, 202343</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202343</td><td style="text-align:right;">274,971</td><td>51, 202344</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202344</td><td style="text-align:right;">276,099</td><td>51, 202345</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202345</td><td style="text-align:right;">271,371</td><td>51, 202346</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202346</td><td style="text-align:right;">272,029</td><td>51, 202347</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202347</td><td>&nbsp;</td><td>51, 202348</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202348</td><td>&nbsp;</td><td>51, 202349</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202349</td><td>&nbsp;</td><td>51, 202350</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202350</td><td>&nbsp;</td><td>51, 202351</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202351</td><td>&nbsp;</td><td>51, 202352</td></tr><tr><td style="height:12.75pt;">MINVENTORY</td><td>MINVENTORY_51_202352</td><td>&nbsp;</td><td>51, 202353</td></tr></tbody></table>

I am trying to add a new one called MINVENTORY_51_2023 with a hig_value of 51,202354

ALTER TABLE XXX.minventory ADD PARTITION minventory_51_202353 VALUES LESS THAN (51,202354) TABLESPACE mmax_minventory_2023

I am getting this error which makes no sense:

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

I cannot see the error above. The error occurs in toad on minventory_51_202353, but it does not exist. I tried to do a split which said it did not exist.

I would appreciate any help an insight.

Thanks

This post has been answered by Dennis Russell on Jan 11 2024
Jump to Answer
Comments
Post Details
Added on Jan 9 2024
4 comments
48 views